Re: [cx-oracle-users] cx_Oracle execute() Performance
Brought to you by:
atuining
From: Mark H. <mh...@pi...> - 2011-02-16 19:04:30
|
On 2/16/11 10:44 AM, Baublitz, Brian wrote: > I also tried batching a set of 249 updates and using > cursor.executemany() yet still encounter the same delay. The batch > update takes about 10 minutes using cursor.executemany(), but only two > seconds through Oracle SQL Developer. do you get the delay if you turn off autocommit? I think by default sqldeveloper doesn't autocommit. |