[rt-devel] Postgres performance.

[Jeroen Ruigrok/asmodai]

-On [20030403 04:32], Aidan Mountford (aidan at oz.to) wrote:
[snip original query]
>The above took 59 seconds on our production DB (and returned 10 rows)

This took me between 320-324 msec on my almost empty database.

[snip optimisation #1]
>This ran in about 6 seconds. (and returned the same 10 rows)

This took about 93 msec.

>And then I tried a little harder...
>
>And this gave the same result in less than one second...

This took me about 49 msec.

I will fill the database some more, do some testing on the
DBIx::SearchBuilder 0.80.0 and then the 0.80.4 queries.

-- 
Jeroen Ruigrok van der Werven <asmodai(at)wxs.nl> / asmodai / a capoeirista
PGP fingerprint: 2D92 980E 45FE 2C28 9DB7  9D88 97E6 839B 2EAC 625B
http://www.tendra.org/   | http://www.in-nomine.org/~asmodai/diary/
Only the wisest and the stupidest of men never change...