Browsing large amout of data

Wojtek · Post by **Wojtek** » Mon 14 Feb 2005 09:49

Hi, I'm using TOraQuery to search for records in database. When the scope is wide, users get all possible data (10MB), but there's only space for 25 records on DBGrid to display. Is there any simple way to get from the database these 25 records (or, let's say, 2x more to make the work more efficient) and NOT ALL OF THEM (because it takes much time) ?

Alex · Post by **Alex** » Mon 14 Feb 2005 14:48

The easiest way is to make your search at the server side (i.e. within your SQL or PL/SQL statement) and set TOraQuery.FetchAll property to false (default setting). In this case you will fetch data from Server with TOraQuery.FetchRows records per piece.
Also see this topic http://crlab.com/forums/viewtopic.php?p=1301#1301 it may be help you.