develooper Front page | perl.beginners | Postings from August 2009

AW: delete 20 000 records in oracle from perl

Thread Previous
Thomas Bätzler
August 17, 2009 02:34
AW: delete 20 000 records in oracle from perl
Message ID:
luke devon <> asked:
> Since i have more binary data to be deleted in the requested query , i
> have to use a external script/program to satisfy the deletion. So thats
> why i wanted to know , how can we implement multi threading for the
> situation.

You said that CPU load is high when deleting the records, and yet you want to do multiple delete queries at once? That doesn't sound like a good idea to me ;-)

Also, if a delete query on a single records takes two minutes, then it might be worth your while to investigate the causes. Is there an index on the key you're using to select rows to delete? Have you had a pro look at the database configuration? I seem to recall that unlike "consumer" DBMS like MySQL, Oracle requires frequent tuning to optimize performance.


Thread Previous Perl Programming lists via nntp and http.
Comments to Ask Bjørn Hansen at | Group listing | About