count(*) VS num_rows
View Single Post
04-02-2009, 08:35 PM
Join Date: Feb 2009
Location: New York
Originally Posted by
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.
50 columns? Is this mySQL? I thought that mysql had a limit of 32 columns per table?
Anyways, most of my tables are only a couple thousand rows long but I want to practice proper or GOOD coding techniques.
In this particular case though, my table has about 350,000 - 500,000 rows, it kinda depends because the data that gets inserted fluctuates, but 500K is about the max that I have seen with 350K as the min.
The number of columns isn't all that much, about 15 columns...
And I TRY to use the best column types although I will admit sometimes I get lazy and don't use the proper types...
For example I have a lot of "varchar" when they should be just "char" etc....
View Public Profile
Send a private message to allworknoplay
Find More Posts by allworknoplay