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

Report message to a moderator

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: 26766
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.

Report message to a moderator

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: 3728
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.

Report message to a moderator

Previous Topic: Performance Issue!!!
Next Topic: index & tables should be separated?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 10:42:48 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.