[PERFORM] CURSOR slowes down a WHERE clause 100 times?

, idcomune) JOIN istat_wpt ON (idwpt = id); Thank you for any hint. -- Niccolo Rigacci Firenze - Italy War against Iraq? Not in my name! ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command

Re: [PERFORM] CURSOR slowes down a WHERE clause 100 times?

of the FETCH, but I got two syntax error... Thanks -- Niccolo Rigacci Firenze - Italy War against Iraq? Not in my name! ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [PERFORM] CURSOR slowes down a WHERE clause 100 times?

On Wed, Jul 06, 2005 at 11:19:46PM +0200, Niccolo Rigacci wrote: I have a performace problem with the following query: BEGIN; DECLARE mycursor BINARY CURSOR FOR SELECT toponimo, wpt FROM wpt_comuni_view WHERE ( wpt setSRID('BOX3D