Mutiple SQL count() from several tables

Mutiple SQL count() from several tables

El Forum
Guest

02-08-2008, 04:23 AM

[eluser]tonanbarbarian[/eluser]
do you have indexes?
make sure that you have an index on the user fields in the pm, posts and login tables
and how many records per table are we talking about?
also you might want to change the COUNT(x.*) to COUNT(x.id) for each of the joined tables, that MIGHT improve performance as well

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