Re: Drupal and PostgreSQL - performance issues?

On Thu, Oct 16, 2008 at 4:40 PM, Stephen Frost <sfrost(at)snowman(dot)net> wrote:
> * Tomasz Ostrowski (tometzky(at)batory(dot)org(dot)pl) wrote:
> I don't see 'limit 1' anywhere in that patch.. And you don't want to
> use 'limit 1' *and* count(*), that doesn't do what you're expecting
> (since count(*) is an aggregate and limit 1 is applied after). You
> really want to do something more like:
>
> select true from tab1 limit 1;
>
> And then test if you got back any rows or not (which might be what
> *your* patch does, hadn't looked at it yet).
>
> Thanks,
>
> Stephen

Seems Tomasz linked to the wrong patch. The patch he meant was:
http://drupal.org/files/issues/drupal_lookup_path-6.x.patch.txt

Or better... he linked to the correct patch (for drupal 5.x) but the
user Earnie made a mistake or something in the 5.x patch, seeing the
comment[1] that the patches should be the same...

Also nice to see people "benchmark" differences by just executing a
query once[2][3]....

Wessel

[1] http://drupal.org/node/196862#comment-648511
[2] http://drupal.org/node/196862#comment-649791
[3] http://drupal.org/node/196862#comment-649928