> I tested this using CF 4.01 using a 9000+ record Access database.
> Using Query.RecordCount was actually about 10-20% faster.
The thing is that Query.RecordCount requires the db server to pull data out
of the database and clog up the lan between it and cf server. Do that on a
busy production server on the application.cfm file, etc and you're going to
notice the performance degradation.
A simple count(*) or preferably count(field) put less resource load on the
overall server/lan.
--min
------------------------------------------------------------------------------
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.
