>>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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:217068 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