Loading only 10000 Records from large table ( Cust. Ledger Entry )

kenyo

Hi, so even after applying filters the table contains still 800.000 - 1.000.000 records. This seems to be too much for the system ( loading for multiple hours ) and I only need 10.000 at a time anyway. Is there a way to only load 10.000 at a time without an extra filter ? something like a "SELECT TOP (10000)" ?

Cheers.

txeriff

well, not sure what you are doing as you are not explaining it, from where that data is coming from being filtered etc but...

some stupid easy solution would be to add a counter and when you reach 10.000 exit:
repeat
vcounter+=1;
//do your stuff.
if vcounter >=10000 then
exit;
until...