Numbers of rows in a table

[johk02]

Hi,

I am using a MySQL dB and I want to know the numbers of records in a table. Are there a more efficient way than using recordcount??

Thanks
Jonas

 

[r937]

oh, you betcha

instead of returning all the rows from the database to coldfusion, and letting coldfusion count them, the better way is to let the database itself count them and then return only the count to coldfusion

select count(*) as c from daTable

r937.com | rudy.ca

 

[johk02]

Thanks works like a charm
But I gues you already knew that

Jonas