Re: Documentation on Transaction Management
- From: scoles@xxxxxxxxxxx
- To: mathias.magnusson@xxxxxxxxx
- Date: Fri, 20 Nov 2009 06:28:29 -0500 (EST)
A simple perl DBD::Oracle script utilizing the
http://search.cpan.org/~timb/DBI-1.609/DBI.pm#execute_array
should only take a few momments for 10m+ records even with binding maybe
there is something else going on like the others say you might have too
many index or other trsanactions going on.
cheers
> How long time does it take to run the update as a single update? Sure
> enough
> undo would need to be allocated, but this would show if the problem is
> with
> the approach or with the database (number of indexes and such). It could
> also show that the simple way actually works fast enough to do the job.
>
> If that turns out to be too slow, then one possible solution would be to
> have multiple parallel jobs operate on different parts of the table.
>
> Can new rows be added to the table while the update runs?
>
> Mathias
>
> On Fri, Nov 20, 2009 at 3:16 AM, rjamya <rjamya@xxxxxxxxx> wrote:
>
>> 10m rows should not be more than a few minutes unless there are lots of
>> active transactions and/or indexes. I'd try to minimize outside lookups
>> and
>> by scanning the table (to be updated) first, get values from lookup
>> tables
>> and cache them locally then run simple updates.
>>
>> Then again we are talking about lack of more info :)
>>
>> Raj
>>
>>
>>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
