[DUG-TO] Speed Optimization

[Alan Dixon]

Also - even before you check your query logs, just run top during a slow
page load and check what's happening. You should see either httpd or mysql,
or both, eating up the cycles. If you don't see either, or if your load
actually stays low, then it may well be something completely different. For
example - one of your modules may be trying to fetch something from another
site, and the latency may be due to a dns issue on your server (notorious),
or the delay may be due to some piece of javascript slowing things down that
has nothing to do with your server at all (though that's less likely if it's
only affecting logged-in users).

I'd also copy the site to a development server and see if the problem looks
the same there.

 - Alan

On Wed, Mar 31, 2010 at 9:29 AM, Design Guru
<subscriptions at designguru.org>wrote:

>
> Thanks for all the tips guys - Khalid, I'll go through the query log later
> today then try to hunt down the culprit(s) from there.... Will post back to
> the list with findings later :)
>
> Cheers,
>
> Qasim
>
> tel: 1.416.642-5469
> fax: 1.647.439-0891
> -
> Design Guru -  http://www.designguru.org
> Using Open Source Software to foster community online.
> -
> Check out Seedling Joomla: http://www.plantseedling.com
>
>
>
> Khalid Baheyeldin wrote:
>
> On Tue, Mar 30, 2010 at 4:35 PM, Design Guru <subscriptions at designguru.org
> > 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!
>>
>>
> Qassem
>
> Before you try too many things, make sure you narrow down the area of the
> problem to one or two, then decide how to attack them.
>
> If you think this is caused by database queries, install the devel module,
> enable the query log. Make it sort by duration.
>
> See if you have a specific query that is slow, or the slowness is all over
> the place.
>
> Do not explore another area until you are sure that the previous area is
> given a clean bill of health.
>  --
> Khalid M. Baheyeldin
> 2bits.com, Inc.
> http://2bits.com
> Drupal optimization, development, customization and consulting.
> Simplicity is prerequisite for reliability. --  Edsger W.Dijkstra
> Simplicity is the ultimate sophistication. --   Leonardo da Vinci
>
> ------------------------------
>
> _______________________________________________
> DUG-TO mailing listDUG-TO at lists.openject.comhttp://lists.openject.com/listinfo/dug-to
>
>
> _______________________________________________
> DUG-TO mailing list
> DUG-TO at lists.openject.com
> http://lists.openject.com/listinfo/dug-to
>
>


-- 
Alan Dixon, Web Developer

Drupal and CiviCRM for Canadian nonprofits.
http://blackflysolutions.ca/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openject.com/pipermail/dug-to/attachments/20100331/3d7f2e80/attachment.htm>