Yep, sorry, lost the thread and didn't notic ethat. The thread has sort of been hijacked now :-)
-----Original Message----- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: 31 August 2005 22:59 To: CF-Talk Subject: Re: Paging through records >>The one your saying is better First, I would like to mention that I'm not the one who came up with this idea, but well ;-) >>1. query all the required records >>2. query a subset of those records >>3. output the records. The BIG difference is that 1. you don't query all required records, but ONLY the ID of every record, which may be thousand times smaller than querying ALL columns, especially if the table has a lot of columns. I cannot confirm that it is the way it works for every database, but to query only one indexed column, the system wouldn't even have to read the table, all data could come directly from the index which is also read anyway. Then you query all columns, but just for a few records. This is the difference. -- _______________________________________ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217074 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
