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?
Printable View
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?
Is your DB properly indexed? What are you using count? Could you do it in PHP instead?