Home » RDBMS Server » Performance Tuning » Help with general preformance increase...
icon4.gif  Help with general preformance increase... [message #214470] Tue, 16 January 2007 10:35 Go to next message
andybyrne55
Messages: 1
Registered: January 2007
Junior Member
Hi, I need to create a database that will insert/delete records in batches of 50,000 up to a max of 2,000,000.

I just want to know what specific performance enhancements would be of benefit to this kind of setup? I've heard about partitioning etc. and just want to know what modifications I can make to get the best performance out of my DB


Any help is greatly appreciated

Thanks
Andrew
Re: Help with general preformance increase... [message #214472 is a reply to message #214470] Tue, 16 January 2007 11:17 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>want to know what modifications I can make to get the best performance out of my DB

A mauve database would be your best choice.
Re: Help with general preformance increase... [message #214522 is a reply to message #214472] Tue, 16 January 2007 19:35 Go to previous message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
You don't want to have to DELETE lots of rows. If you partition by batch, you can just truncate the partition. Here are some other ideas on bulk DML.
Previous Topic: Performance Issue!!!
Next Topic: index & tables should be separated?
Goto Forum:
  


Current Time: Sun Dec 11 04:29:51 CST 2016

Total time taken to generate the page: 0.04724 seconds