Re: [SQL] PERSISTANT PREPARE (another point of view)

2008-07-20 Thread Milan Oparnica
Richard Huxton wrote: >>Milan Oparnica wrote: >> >>It's simply to complicated to return recordsets through >>server-side stored procedures. They are obviously designed to do >>complex data manipulation ... > Richard wrote: >I'm not convinced it's always a win one way or another. >

Re: [SQL] PERSISTANT PREPARE (another point of view)

2008-07-20 Thread Milan Oparnica
Richard Huxton wrote: >>Milan Oparnica wrote: >> >>It's simply to complicated to return recordsets through >>server-side stored procedures. They are obviously designed to do >>complex data manipulation ... > Richard wrote: >I'm not convinced it's always a win one way or another. >

Re: [SQL] PERSISTANT PREPARE (another point of view)

2008-07-20 Thread Milan Oparnica
Pavel wrote: try to write prototype and show advantages... Prototype of what, implementation into Postgre or just efficiency of PRESISTANT PREPARE idea ? ...but I see some disadvatage too. Mainly you have to manage some shared memory space for stored plans. It's not easy task - MySQL dev