Re: [cx-oracle-users] How to optimize (Pro*C is 5x faster)?

[Jim B. <ma...@ji...>]

Anthony,

I'm curious about your point (e). Would this in particular be 
executemanyprepared()? And if so, are there any examples of its use? 
There was some discussion about it 
(http://mail.python.org/pipermail/db-sig/2004-April/004026.html), but no 
actual examples. Instead the discussion veered off to the use of 
external tables, but for me, external tables have too many DBA issues to 
actually use.

- Jim


Anthony Tuininga wrote:

> A few points:
>
> ...
>
> e) If you really need performance and don't mind deviating from the DB 
> API to get it, there are a number of methods that can be used to avoid 
> the overhead of creating result tuples and binding parameters. This 
> will definitely bring the performance numbers more in line with the 
> Pro*C numbers but at the cost of less portable code.