Mutiple SQL count() from several tables

Mutiple SQL count() from several tables

El Forum
Unregistered

#12

03-25-2008, 05:42 AM

[eluser]GSV Sleeper Service[/eluser]
you can use count(1) instead of count(*) for a slight perfomance boost.
it's probably worthwhile sticking EXPLAIN in front of your query to see where the bottleneck is.

Messages In This Thread

Mutiple SQL count() from several tables - by El Forum - 02-08-2008, 12:57 AM

Mutiple SQL count() from several tables - by El Forum - 02-08-2008, 03:18 AM

Mutiple SQL count() from several tables - by El Forum - 02-08-2008, 03:56 AM

Mutiple SQL count() from several tables - by El Forum - 02-08-2008, 04:23 AM

Mutiple SQL count() from several tables - by El Forum - 02-08-2008, 04:26 AM

Mutiple SQL count() from several tables - by El Forum - 02-08-2008, 05:20 AM

Mutiple SQL count() from several tables - by El Forum - 02-08-2008, 08:34 PM

Mutiple SQL count() from several tables - by El Forum - 02-12-2008, 04:41 AM

Mutiple SQL count() from several tables - by El Forum - 03-25-2008, 05:04 AM

Mutiple SQL count() from several tables - by El Forum - 03-25-2008, 05:25 AM

Mutiple SQL count() from several tables - by El Forum - 03-25-2008, 05:38 AM

Mutiple SQL count() from several tables - by El Forum - 03-25-2008, 05:42 AM