Site Is So Slow!

Site Is So Slow!

El Forum
Guest

01-12-2009, 10:23 AM

[eluser]Krzemo[/eluser]
Group by seems obligatory as you are counting records there...

1)
I dont see a point in all those joins which you are not using at all in output.
I can see that you are getting data only from
meet_events
events
meet_athletes
coaches

wile having 6 tables joned and not making any conditions on those unused...

2)
Im not sure how it works in MySQL but in Oracle using statment like Meet_Event.* instead of listing all columns literaly like Meet_Event.id, Meet_Event.name etc also gives some overheads (this migh be as small as one ms, but when multiplied by 10 000 page loads...)

3)
I would run tuned query and get its explain plan to see what else we can do about tables underneath it.

Thats for the begining...

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