Partial query execution - is it posible?

S

slilov

New Member
Hi,
I want to execute a query (and to populate the results in a browse widget) in parts. I work with hudge queries, searching among lots of records, which executing takes long time (I have the right indices in DB).
So I want to get results from any query by groups of, let's say 10 records, to display these records in a browser and to have buttons "Next 10" and "Prev 10" to fetch next or previous group. I think this is quite a common problem, so I don't want to code it by myself from the ground up. Would anyone send me some code which do this?
Thanks in advance!
Simeon Lilov
 
Hi,

I dont think you need to build this ground up... if I understood your requirement.

Have you taken a look at parameters in DEFINE QUERY...like CACHE.
Have you looked at OPEN QUERY with options LOOKAHEAD and NO-LOOKAHEAD.

hth
V
 
Use a Buffer, have a counter var that reads in the desired num of records, display those records then when you wish for more records fill the buffer again.
 
You must log in or register to reply here.
Back
Top