> If you do a select * and then do a record count you have to
> perform 2 operations. Select count(*) is only one so I think
> you are right - count(*) will be faster but it'll be negligible
> unless you have a huge amount of records
Actually, the difference can be pretty significant even with average working
recordsets. One reason for this is that when you use COUNT(), you're
generally only returning one single record from the database. When you use
CF to count records, you actually have to retrieve them all, which can be
time-consuming.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
