[DUG-TO] Speed Optimization

[Julian Egelstaff]

Indexes!  I don't know what modules you're using, but 1 minute sounds 
really excessive, and it could be that some module you're using is doing 
a bunch of behind the scenes joins on things, and the tables involved 
aren't indexed on the fields that are being used in the joins.  If you 
index the tables, which is a trivial few clicks in phpmyadmin, then you 
can sometime improve performance by about 100 times.

But that's only true if this is your issue, so you would have to do some 
actual profiling of what queries are being run, which ones are taking 
the longest, and what tables and fields are being used.

Sometimes, the only way to fix this stuff is to re-architect the data 
structure....super large sites will split certain tables off into a 
separate database (google sharding), but at that point, you're usually 
talking about a digg.com or livejournal or something like that.  And I 
would guess you're not there yet, so therefore I would not pursue those 
kinds of fixes...they're probably not the sweet spot for improving your 
performance.

--Julian

Design Guru wrote:
>
> Hey guys,
>
> I really need help optimizing the speed of this site I built with 
> Drupal 6 - have tried tons of things to get it faster but am butting 
> my head against the wall! http://juma.ca
>
> Can you help me speed things up?  It seems like the speed is totally 
> tied to database calls... I've got caching turned on for anon users 
> and they're generally viewing the site quickly but for authenticated 
> users speeds are erratic and at times take 1min to load a view/page?!!
>
> Any recommendations of reads or people to help speed things up are 
> recommended!
>
> Thanks,
>
> q./
>