View Full Version : anything other than COUNT?

03-07-2004, 01:48 PM
whenever i use the COUNT(*) function in mysql it seems to take about 5 seconds for a page to load opposed to < 1 sec. does that make any sense, and is there any alternative to the COUNT function?

03-07-2004, 04:43 PM
Is your DB properly indexed? What are you using count? Could you do it in PHP instead?