| From: | Tomasz Ostrowski <tometzky(at)batory(dot)org(dot)pl> |
|---|---|
| To: | Mikkel H?gh <mikkel(at)hoegh(dot)org> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Drupal and PostgreSQL - performance issues? |
| Date: | 2008-10-16 08:54:47 |
| Message-ID: | 48F70157.7010601@batory.org.pl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
On 2008-10-16 10:34, Mikkel Hogh wrote:
> It's not only to avoid one query, but to avoid one query every time
> drupal_lookup_path() is called (which is every time the system builds
> a link, which can be dozens of time on a page).
Oh, $count is static. My bad. Using count for testing for empty table is
stupid nonetheless.
There is an issue report with lengthy discussion on drupal.org:
http://drupal.org/node/196862
And a proposed patch:
http://drupal.org/files/issues/drupal_lookup_path-5.x.patch.txt
which uses "limit 1". This patch is not applied though. I don't know why.
Please retest with this patch. And keep the CC to the list in your messages.
Regards
Tometzky
--
...although Eating Honey was a very good thing to do, there was a
moment just before you began to eat it which was better than when you
were...
Winnie the Pooh
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Morgan Lloyd | 2008-10-16 09:00:37 | Re: Numbering rows |
| Previous Message | Mikkel Høgh | 2008-10-16 08:34:07 | Re: Drupal and PostgreSQL - performance issues? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ivan Sergio Borgonovo | 2008-10-16 14:07:56 | further tests with 8.3 was: Re: Drupal and PostgreSQL - performance issues? |
| Previous Message | Mikkel Høgh | 2008-10-16 08:34:07 | Re: Drupal and PostgreSQL - performance issues? |