p.s. 10K records may sound like a lot but it's typically only cached for a couple of mins, or until a new report is run by that user. Our systems are pounded each day by both internal and external folks and cfmx is rock solid using this technique.
We're in finance so many of these systems are OLTP...caching on the report servers also take some heat off the DB's. -Stace -----Original Message----- From: Stacy Young Sent: Wednesday, August 31, 2005 3:20 PM To: '[email protected]' Subject: RE: Paging through records One technique I've found to be very effective is to cache the recordset and page from there...I'll normally set a limit of 10,000 rows. (I base this off record counts from summary roll-up screens) If the amount exceeds that I fall back to leveraging rownum (Oracle) to retrieve subsets. -Stace -----Original Message----- From: Snake [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 30, 2005 4:13 PM To: CF-Talk Subject: Paging through records Like pretty much everyone else, I have always used the following method for paging through result sets, <cfoutput query="whatever" startfrom="#startfrom#" maxrows="#maxrows#"> And altering those variables to allow 200 records per page or whatever, But this means querying ALL records form the database each time, which can be very excessive when your dealing with a very large database. Has anyone come up with a good solution of only querying the records you actually need (rows 40 -59 for example). Russ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217041 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
