Can I write the query in such a way that it takes advantage of the row number in the URL to fetch just enough rows for display? The built-in hdb browser already does that. If I keep the resultset as an in-memory table it will take up memory, which is limited by kdb 32 bit. Thx.
I’m not exactly sure what you mean. Do you mean you want to see the entire result without paging?
As I mentioned in the other thread, you can increase buffer lilmit by executing system “C 2000 2000” in q. However, the web/console limit seems to be 2000 rows. Not sure is a way to change that limit
All 50k rows are re-calculated (notice the pause) every time I click the pageDown link. Can I write the query to take the row number in the pageDown link as a parameter and compute only the rows needed for display? Thx.
I don’t even have the time to compute the full resultset in the first place. Memory consumption is another problem. The user is NOT LIKELY to cleanup after use.