[development] Re: Database queries on drupal.org

[Ken Rickard]

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

http://drupal.org/node/75976

With the full test results attached here:

http://drupal.org/files/issues/benchmark.txt

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
agentrickard


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