nlv11281 at natlab.research.philips.com
Thu Sep 28 06:51:56 EDT 2006
> You probably need to think about tuning your database a bit to see if you can > speed things up. Make sure that you have the correct indices in place and > than you are using limit/offset as best you can. This is really a database > problem as much as a web app design issue. In other words, if your SQL query > to get a "page" of data takes 3 seconds, this is a database issue, which I > suppose it is. It's also a UI issue. Who would want a user to browse through 10000 records in pages of 100 records? The UI should allow some method of limiting or summarizing the results.