Does Count(*) consume more memory?
View Single Post
12-24-2008, 03:51 PM
Join Date: Sep 2007
Originally Posted by
i think they would both use about the same seeing as whichever you use they both just count the nunber of rows.
But the wildcard key gives SQL more to do, SELECT * FROM table is almost always slower than SELECT id,username,othercolumn1,ect FROM table
View Public Profile
Send a private message to Village Idiot
Find More Posts by Village Idiot