Site Is So Slow!

Site Is So Slow!

El Forum
Guest

01-12-2009, 10:27 AM

[eluser]Hockeychap[/eluser]
Oops - no don't take out the group by statement - you'll need it for the count(). Although there is a bug in the the group by / order by scenario when there is an union of multiple tables.

I'll have a look at the query in detail on the train home tonight, but first thought is to make sure you have indicies on all the join columns.

Messages In This Thread

Site Is So Slow! - by El Forum - 01-09-2009, 08:20 AM

Site Is So Slow! - by El Forum - 01-09-2009, 10:47 AM

Site Is So Slow! - by El Forum - 01-09-2009, 02:10 PM

Site Is So Slow! - by El Forum - 01-09-2009, 03:23 PM

Site Is So Slow! - by El Forum - 01-12-2009, 09:02 AM

Site Is So Slow! - by El Forum - 01-12-2009, 09:30 AM

Site Is So Slow! - by El Forum - 01-12-2009, 10:23 AM

Site Is So Slow! - by El Forum - 01-12-2009, 10:27 AM

Site Is So Slow! - by El Forum - 01-12-2009, 11:46 AM

Site Is So Slow! - by El Forum - 01-12-2009, 11:58 AM

Site Is So Slow! - by El Forum - 01-12-2009, 12:04 PM

Site Is So Slow! - by El Forum - 01-12-2009, 12:10 PM

Site Is So Slow! - by El Forum - 01-12-2009, 12:36 PM

Site Is So Slow! - by El Forum - 01-12-2009, 12:55 PM

Site Is So Slow! - by El Forum - 01-12-2009, 01:02 PM

Site Is So Slow! - by El Forum - 01-12-2009, 01:03 PM

Site Is So Slow! - by El Forum - 01-12-2009, 01:06 PM

Site Is So Slow! - by El Forum - 01-12-2009, 01:09 PM

Site Is So Slow! - by El Forum - 01-12-2009, 01:16 PM

Site Is So Slow! - by El Forum - 01-12-2009, 01:17 PM

Site Is So Slow! - by El Forum - 01-12-2009, 01:23 PM

Site Is So Slow! - by El Forum - 01-12-2009, 01:35 PM

Site Is So Slow! - by El Forum - 01-12-2009, 02:07 PM

Site Is So Slow! - by El Forum - 01-12-2009, 03:52 PM

Site Is So Slow! - by El Forum - 01-12-2009, 04:28 PM

Site Is So Slow! - by El Forum - 01-12-2009, 05:00 PM

Site Is So Slow! - by El Forum - 01-12-2009, 05:28 PM

Site Is So Slow! - by El Forum - 01-12-2009, 05:45 PM

Site Is So Slow! - by El Forum - 01-12-2009, 06:20 PM

Site Is So Slow! - by El Forum - 01-12-2009, 06:47 PM

Site Is So Slow! - by El Forum - 01-12-2009, 07:21 PM

Site Is So Slow! - by El Forum - 01-12-2009, 09:38 PM

Site Is So Slow! - by El Forum - 01-13-2009, 03:22 AM

Site Is So Slow! - by El Forum - 01-13-2009, 04:13 AM

Site Is So Slow! - by El Forum - 01-13-2009, 06:14 AM

Site Is So Slow! - by El Forum - 01-13-2009, 07:20 AM