Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
PerlMonks  

Re: Perl DBI (sybase) rapidly delete large number of records

by mpeppler (Vicar)
on May 08, 2007 at 15:55 UTC ( #614180=note: print w/replies, xml ) Need Help??


in reply to Perl DBI (sybase) rapidly delete large number of records

Like jfroebe said - the most likely problem is that you don't have the correct index on the target table - this sounds like a table scan for each row you delete, which seems to match the performance problems you see.

Michael

  • Comment on Re: Perl DBI (sybase) rapidly delete large number of records

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://614180]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (7)
As of 2020-12-01 12:24 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    How often do you use taint mode?





    Results (6 votes). Check out past polls.

    Notices?