Devart Forums

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) ?

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.