May connections share same prepared statement?

Hi, (Sorry if this posting has appeared already.) With ESQL/C in Client SDK 2.20, can I prepare a statement once, and then use it in other connections? In other words, is it possible to prepare a statement with one connection active, and then execute the statement with another connection active? Regards, Per

Per Frykenvall (per.frykenvall@got.wmdata.se) wrote: : once, and then use it in other connections? In other words, : is it possible to prepare a statement with one connection : active, and then execute the statement with another : connection active? There was a presentation on this subject at SP'99. You should be able to find it on the IFMX web site. There is a new feature in the Foundation.2000 release called 'Shared Statement Cache'. Prepared queries from all concurrent connections reside in a shared cache on the server. So if you have a single application being used by lots of people, then the prepared queries (the plans) are re-used automatically. Only in Foundation.2000 though. -- ===================================================================== Paul Brown ^..^ pbrown@postgres.Berkeley.EDU (oo) - Oink! #include <std_disclaimer.h> "Think global - act loco!" - Zippy the Pinhead =====================================================================