[GENERAL] Unusual slowdown using subselects

2001-05-18 Thread John Aughey
he two queries should be nearly identical, but this one runs very slowly. Can anyone explain why this happens and/or how I can do a sub-select like this and get fast results? Thank you John Aughey ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[GENERAL] Unusual slowdown using subselects

2001-05-16 Thread John Aughey
he two queries should be nearly identical, but this one runs very slowly. Can anyone explain why this happens and/or how I can do a sub-select like this and get fast results? Thank you John Aughey ---(end of broadcast)--- TIP 5: Have you checked our