• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 513
  • Last Modified:

Retrieving data from data base using Chunk size

I have a large table contains millions of records.  Is there a way I can set from database level using chunk size?  For example every time retrieving 100 chunks, this way I only need three times to find the record I want.

Thanks in advance.
0
meimeius
Asked:
meimeius
1 Solution
 
YodaMageCommented:
Not in any database I've ever seen. Though what you want to do does sound not unlike 'Fetch' size, which is almost always ajustable.

What dataset?



Second thought, what are you doing that is requiring a fetch of that many records.......?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now