We currently use a JQuery grid and SQLite database to store and display historical data to users. Because of the time it takes to query the DB and write the grid rows, we populate one screen of grid rows at a time. The users are now agitating for a scrollable grid, on data that can be 10-15,000 rows. We have the alternative to store the data in one column in the SQLlete DB, and then have SQL code retrieve the column value to a variable and have jqxgrid code parse the variable (CSV format) to populate the grid.
Is that practical at all? Can the grid load be paged so that the visible wait time is minimized? This is not about absolute speed, but getting the best possible performance. As I remind teh users, speed is relative.
On a related issue, what is VirtualMode and what are the implications (if any) to this process?
