Perl may not be the whole answer.

In Oracle if I have a lot of deletes to do in a large database, I use partitioned views to spread the work out. I also drop as many indexes as I can so that the index overhead is removed until I am done deleting and then I reindex.

The partitioned views will help the update issue also, since the actual database will be spread across multiple disks. Also make sure that your temp space is not on the same disks as your database and indexes.

I would also optimize my segment management and use stored procedures for the updates and deletes. You can have Perl call the stored procedures if you want.

Overall I would tune my database side first, and then work on concurrent SQL processes.

Richard

There are three types of people in this world, those that can count and those that cannot. Anon

In reply to Re: Threading (Perl 5.8 ithreads) with Oracle 9i dumps core by richardX
in thread Threading (Perl 5.8 ithreads) with Oracle 9i dumps core by fx

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.