count(*) VS num_rows
View Single Post
04-02-2009, 08:19 PM
Join Date: Sep 2007
The query looks good to me.
Out of interest, how many rows are you pulling from. I was able to pull COUNT(*) from a database at work that has 125,000 rows with about 50 columns (I did not deign this table) in less than one second.
View Public Profile
Send a private message to Village Idiot
Find More Posts by Village Idiot