[development] Two performance improvements

[Rob Barreca]

>
> I also found devel.module measuring very unreliable in my opinion. The
> slow queries are logged on random basis, query A executes in 50ms first
> time and in 1ms second time...
This is most likely due to MySQL query caching.  Most queries can be 
cached so identical resulting queries will be very quick and it appears 
that is what you're seeing.

Rob Roy Barreca
Electronic Insight Corporation
12526 High Bluff Drive, Suite 300
San Diego, CA 92130
http://www.electronicinsight.com
rob at electronicinsight.com



Jakub Suchy wrote:
>> You can create a test site and populate it with as many nodes as you  
>> need using the generate-content.php script that ships with  
>> devel.module.  There are other scripts in there for creating users,  
>> taxonomy terms and even path aliases.  Devel module is also great for  
>> timing db queries.
>>     
>
> Hi,
> i started debugging one of my sites using Drupal 4.6, which is taking
> about 1second to generate, which is probably slow (using few modules and
> 18n for 6 languages).
>
> I found this query is not using index:
> SELECT locale, name FROM locales_meta WHERE enabled = 1 ORDER BY isdefault DESC, name ASC;
> This may be fixed using:
> ALTER TABLE locales_meta ADD INDEX(enabled);
> But i am not experienced in developing Drupal core yet, so could
> somebody adopt this issue and add it to CVS please?
>
> This query is executed more than 11 times every time:
> SELECT s.lid, t.translation FROM locales_source s INNER JOIN locales_target t ON s.lid = t.lid WHERE s.source = '' AND t.locale = 'cs'
> I don't understand where may appear empty locale string and can't
> imagine how to debug this, can anybody help?
>
> I also found devel.module measuring very unreliable in my opinion. The
> slow queries are logged on random basis, query A executes in 50ms first
> time and in 1ms second time...
>
> Jakub Suchy
>
>
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/development/attachments/20060711/ab725437/attachment.htm