Обсуждение: Subqueries?

hi, hackers!
do you plan some improvments on subqueries?
Unfortunately, in v6.3.2 they often works very slowly, and thus
are useful only on quite small tables :-(

Thanky you
Aleksey.

Aleksey Dashevsky wrote:
>
> hi, hackers!
> do you plan some improvments on subqueries?
> Unfortunately, in v6.3.2 they often works very slowly, and thus
> are useful only on quite small tables :-(

Nothing...
If you use IN then try to rewrite your queries with EXISTS
if possible...

Vadim

> hi, hackers!
> do you plan some improvments on subqueries?
> Unfortunately, in v6.3.2 they often works very slowly, and thus
> are useful only on quite small tables :-(
>

This is the first report of subquery slowness I have heard.  We have
fixed a problem where using an oid in the subquery caused a loop, but
other than that, everything seems fine.  How about sending us some
queries that are slow, and perhaps we can suggest something.


--
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)