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

[Anthony T. <an...@co...>]

The only examples are to be found in CopyData.py which is part of the 
cx_OracleTools package found at http://starship.python.net/crew/atuining.

The documentation for its use (albeit sparse) is to be found in the 
online documentation found at the same web site or included in the 
cx_Oracle package. If you have some particular questions about it, feel 
free to ask. I'll see whether I can explain it better.

Jim Baker wrote:
> 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.
> 
> 
> 
> 
> 
> -------------------------------------------------------
> The SF.Net email is sponsored by: Beat the post-holiday blues
> Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek.
> It's fun and FREE -- well, almost....http://www.thinkgeek.com/sfshirt
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

-- 
Anthony Tuininga
an...@co...

Computronix
Distinctive Software. Real People.
Suite 200, 10216 - 124 Street NW
Edmonton, AB, Canada  T5N 4A3
Phone:	(780) 454-3700
Fax:	(780) 454-3838
http://www.computronix.com