Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

Re: Re: Re: Threading (Perl 5.8 ithreads) with Oracle 9i dumps core

by fx (Pilgrim)
on Jan 02, 2004 at 15:34 UTC ( [id://318332] : note . print w/replies, xml ) Need Help??


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

It just goes to show that you should always think about the big picture. After I went back to the DBA and complained about the speed it was discovered that one of the foreign keys used for joining was not indexed. Adding this index speeded one of the cascaded deletes up from 3-5 seconds to "very quick".

I now have reasonable speed from the SQL calls but my problem still lies in the fact that it can take hours to apply a "big" update which I have just been told is around 110,000 records.

I am therefore still looking for some way to increase the performance of my code.

  • Comment on Re: Re: Re: Threading (Perl 5.8 ithreads) with Oracle 9i dumps core

Replies are listed 'Best First'.
Re^4: Threading (Perl 5.8 ithreads) with Oracle 9i dumps core
by elf_firein (Acolyte) on Jan 06, 2009 at 09:18 UTC
    Hi fx, Have you become able to solve this problem? I am getting similar error after 10000 records. You can see my post also. With Regards, kaustuv