macromedia.coldfusion.database_access
[Top] [All Lists]
<prev [Date] next>
Google
 
<prev [Thread] next>

Re: recordcount without query

from [Adam Cameron]
Subject: Re: recordcount without query
From: Adam Cameron <adam_junk@xxxxxxxxxxx>
Date: Sun, 24 Feb 2008 09:35:00 +0000
Newsgroups: macromedia.coldfusion.database_access 

If you have a primary key on the table, ir shouldn't take too long for
SELECT COUNT(*) FROM table to execute.

I'm not aware of a better way of doing it than that.

*why* do you need to know the row-count of the table on a regular basis?

-- 
Adam
[More with this subject...]
<Prev in Thread] Current Thread [Next in Thread>
Previous by Date:  recordcount without query, JFLaplante
Next by Date:  Re: recordcount without query, Adam Cameron
Previous by Thread:  recordcount without query, JFLaplante
Next by Thread:  Re: recordcount without query, Adam Cameron
Indexes:  [Date] [Thread] [Top] [All Lists]