You don't return them every page, return the records once at the beginning, store it in memory (session,client,application,server) then after that just display the part of the record set you want.
Just a suggestion. -------------- Ian Skinner Web Programmer BloodSource Sacramento, CA -----Original Message----- From: Rodrigo Cohen [mailto:[EMAIL PROTECTED] Sent: Thursday, July 03, 2003 11:16 AM To: CF-Talk Subject: Pagination issues Ian, the problem is, that i dont want to return all 1000 rows on every page. This cause a performance degradation, so i look for another way to solve my problem... Thanks, Rodrigo Cohen. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
