Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

Re: Record edition management strategy needed

by simonm (Vicar)
on Sep 08, 2003 at 16:25 UTC ( [id://289807]=note: print w/replies, xml ) Need Help??


in reply to Record edition management strategy needed

Don't put a lot of work into optimization unless you have a good reason to believe it's going to make a difference. Because each database server behaves differently, this probably requires some local testing to determine what makes sense in your particular context.

Try creating a script with the Benchmark module that compares the time required for 1000 updates of all columns, and 1000 updates of just one or two columns, and see if the difference is significant enough to make it worth your while.

  • Comment on Re: Record edition management strategy needed

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others goofing around in the Monastery: (3)
As of 2024-04-25 07:52 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found