> I've attached an updated version of Karel Zak's pg_qcache patch, which > adds PREPARE/EXECUTE support to PostgreSQL (allowing prepared SQL > statements).
Woah :-)) Thanks Neil! You may be remind of a thread in february, where I talked about a survey about migrating from Oracle 8.0 / NT4 to PostgreSQL 7.2 / Red Hat 7.2 ... Overall performances obtained are a ratio of 1,33 on standard queries of the application, like on migrated CONNECT BY Oracle statements (thanks again to OpenACS guys for this). This ratio is very good for us and our customer. We felt some pride about such results. But we faced a problem in migrating bulk plain batch in Oracle Pro*C to ECPG: performances where 3 times slower, due to incapacity of PG to prepare statments (some well informed guys here in PG list gave us tips&hints to use SPI's prepared statment. Unfortunately, this would result in a loss of functionalities from Pro*C to ECPG.. :-( so we had to abandon this issue). I talk here about CURSORs. I imagine that with your patch, we could prepare statments used in cursors. We going to test this and benchmark the application. Not sure it works, I think ECPG has first to take into consideration those new functialities (Michael?). Be sure to have feedback on this :-) Thanks again for such initiative! I'm going to inform my co-worker (C++ senior) on your patch with the hope he can help you. Cheers, -- Jean-Paul ARGUDO IDEALX S.A.S Consultant bases de données 15-17, av. de Ségur http://www.idealx.com F-75007 PARIS ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
