[DUG-TO] Speed Optimization

[Andre Molnar]

Shame its not closer: as I type there is a mysql performance talk going
on in Montreal.
http://groups.drupal.org/node/56068

As mentioned in this thread:
Database:
table indexes should be checked to see that they are in place.
MySQL query cache can be enabled.

Devel module to show you 'slow' queries - and mysql EXPLAIN command to
see why.

PHP:
APC for PHP op code caching

Random thought:
Before you do that also check that you aren't doing views that use 'now'
as a date field argument.  The query will always have to be rebuilt for
every single page view.

andre
On 3/30/2010 4:35 PM, 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./
>