if i first do prepare blah as SELECT ....., then run execute blah, the time goes down to about 275ms (i had been running this query a lot, and did a vacuum update before all this).
If you make it an SQL stored procedure, you get the speed up of the PREPARE command, without having to prepare manually all the time.
Chris
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
