Re: Large OR query
От | Mitch Vincent |
---|---|
Тема | Re: Large OR query |
Дата | |
Msg-id | 00a301c0f34e$cc123d80$1251000a@Mitch обсуждение исходный текст |
Ответ на | Large OR query (Zak McGregor <zak@mighty.co.za>) |
Ответы |
RE: Large OR query
Re: Large OR query |
Список | pgsql-general |
Is populating another table with the 1000 values and doing a SELECT * FROM <whatever> WHERE <something> IN (SELECT <something> FROM <whatever>) ? I'm not entirely sure that it will yield a better result but it's worth a try. -Mitch ----- Original Message ----- From: "Zak McGregor" <zak@mighty.co.za> To: <pgsql-general@postgresql.org> Sent: Tuesday, June 12, 2001 8:42 AM Subject: [GENERAL] Large OR query > Hi all > > If I have say 1000 values for an ID field, what is the best way to > select from a table all the corresponding records? > I have tried > select * from blah where id in (id1,id2,id3...id1000) > and > select * from blah where id=id1 or id=id2 ... or id=id1000 > > and both are pretty slow. > Is there a better way to do this please? > > Thanks > > Ciao > -- > Zak McGregor http://www.carfolio.com - Over 7000 car specs online > Web mercenary - currently for hire. Perl/html/.js/sql/cgi/GNUlinux/php + > --------------------------------------------------------------------- > "Trying to make bits uncopyable is like trying to make water not wet. > The sooner people accept this, and build business models that take > this into account, the sooner people will start making money again." > -- Bruce Schneier > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://www.postgresql.org/search.mpl >
В списке pgsql-general по дате отправления: