[DUG-TO] Speed Optimization

[Ashok Modi GMAIL]

If you have devel turned on, you might be able to find out which modules are causing the worst set of queries (or how many queries are running on the page if you haven't done that already).  I have seen sites that run into caching issues, memory issues (I see you using imagecache on the site - that can take up a fair bit of memory) - are you also running APC on the server for op-code caching?  That might help as well.

-Ashok

On Mar 30, 2010, at 1:57 PM, Julian Egelstaff wrote:

> 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./
>> 
> 
> _______________________________________________
> DUG-TO mailing list
> DUG-TO at lists.openject.com
> http://lists.openject.com/listinfo/dug-to