Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked

Re: How can I improve the sql statements applying efficiency

by mpeppler (Vicar)
on Aug 15, 2010 at 07:49 UTC ( #855131=note: print w/replies, xml ) Need Help??

in reply to How can I improve the sql statements applying efficiency

Like others have pointed out - this is a database issue, not a perl issue.

You need to look at the query plan generated for the delete and each of the select statements to ensure that these are as optimal as possible.

Then you may need to look at the server itself to see if you can tune the User Log Cache, and maybe bind a specific named cache to the database's log using 4k IO (i.e. two pages) as this can improve things as well. You also need to look at the actual disk IO subsystem to ensure that this is properly configured.


  • Comment on Re: How can I improve the sql statements applying efficiency

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://855131]
[robby_dobby]: This anonymonk's post reads weird to me
[robby_dobby]: Other than the content, that Chrome would not allow submitting code sounds like something funky going on there :P
[erix]: lazyness-driven inventio :)
[erix]: "the dog ate my homework"
[Eily]: looks more like "all my plates are broken and I don't understand why. Also I can't retrieve the broken parts because the elephant in the room is on the way"
[ambrus]: Eily: also webpages aren't displayed on my monitor no matter what I click with the mouse, and there's a blackout right now, could that be a problem?

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (10)
As of 2017-04-25 13:07 GMT
Find Nodes?
    Voting Booth?
    I'm a fool:

    Results (453 votes). Check out past polls.