[development] Re: Database queries on drupal.org

Ken Rickard agentrickard at gmail.com
Tue Aug 1 17:00:28 UTC 2006

I ran a set of crude benchmarking tests on my path_alias lookup patch.  The
results are reported here:


With the full test results attached here:


While the number of database queries drops substantially, the actual
processing time goes up, as both Requests per Second and Transfer Rate drop
after the patch is applied.

This may be due to the placement of variable_get() in the patch, but more
likely, it seems that using the PHP-based check (which requires array
handling) just shifts the load from the database to memory.

I'd be interested to see other (more technically expert) people try this
patch and test it to see if the results are the same.

- Ken Rickard

On 7/29/06, Ken Rickard <agentrickard at gmail.com> wrote:
> I have rerolled the path_alias lookup patch, this time with a working
> admin.
> (I blame last night's failure on free OSCon beer!)
> This patch allows admins who have enabled the path module to go to
> admin/path/configure
> And select paths to allow lookups for from a checkbox list.
> Any paths not selected will not be invoked during drupal_lookup_path.,
> These requests are intercepted within the url() function.
> The issue is described here: http://drupal.org/node/75976
> Again, this is a proof-of-concept patch, designed to see if it buys us any
> performance gains.
> I do need some larger-scale testing, if anyone is willing.
> - Ken Rickard
> agentrickard
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/development/attachments/20060801/e4fa4a59/attachment-0001.htm

More information about the development mailing list