LOAD * WHERE RECNO() >= ($(currentPointer($(currentBreak), $(rowsToLoad)))) AND RECNO() < ($(nextPointer($(currentBreak), $(rowsToLoad)))); // Loads all records between points X and Y SQL SELECT * From database ORDER BY id;
will indeed load all records from the DB and filter afterwards within QV.
Try to create the where part within the SQL statement.
Additionally you could create multiple small QVDs (one for each SQL Select) instead of one large QVD and load them like
LOAD * FROM *.qvd (qvd);
in your application.
hope this helps