Re: More grist for the PostgreSQL vs MySQL mill

From: "Harald Armin Massa" <haraldarminmassa(at)gmail(dot)com>
To: "Peter Rosenthal" <voiperster(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: More grist for the PostgreSQL vs MySQL mill
Date: 2007-01-22 12:26:23
Message-ID: 7be3f35d0701220426r2abb364n3c2b1b5a5d7cbce2@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
> >> select * from table where table_id in (?, ?, ?, ?, ?, ?, ?, ...)
>
>
I usually try to rewrite this kind of queries to

select whatever from table t1 join
(select table_id from xxxxx where xxxxx) t2 using (table_id)

And 3 out of 4 this performs better on Oracle and PostgreSQL.

Would be curious why it does , but usually I am happy that it does:)

Harald

--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
fx 01212-5-13695179
-
Python: the only language with more web frameworks than keywords.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Engada 2007-01-22 12:57:37 Re: Installing Postegres side-by-side with M$ SQL server]
Previous Message Peter Rosenthal 2007-01-22 11:49:29 Re: More grist for the PostgreSQL vs MySQL mill