Two totally different beasts. If you want to pull data back from the
database and then determine how many rows were returned, use
query.recordcount rather than going back to the database for a row count.
If you only want to find out how many rows but don't need the data, then
count() is your best bet rather than pulling the data across the wire and
using CF's recordcount.
SQL vs. CF . . . two separate beasts, or was that two separate mutants? Or
was that thread on fusebox? I'm confused now! ;)
Dan
-----Original Message-----
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 06, 2000 9:12 AM
To: [EMAIL PROTECTED]
Subject: count() or recordcount
Which is faster? I'm presuming count() or what else would it be good for?
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
----------------------------------------------------------------------------
--
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.
------------------------------------------------------------------------------
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.
