Subqueries?

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)