Welcome Guest, Not a member yet? Register   Sign In
Site Is So Slow!
#8

[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: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



Theme © iAndrew 2016 - Forum software by © MyBB