Home » RDBMS Server » Performance Tuning » IMPROVE PERFORMANCE WHEN INSERT RECORDS
IMPROVE PERFORMANCE WHEN INSERT RECORDS [message #305485] Tue, 11 March 2008 00:15 Go to next message
curlybird
Messages: 2
Registered: March 2008
Junior Member
Hi all,

I have a 27 insertion statement.

For each insertion statement, I can insert 400,000 records. That's why the performance is very low.

The sql is like this:

insert into PARTY_XBUY select party_c,50,4,sysdate from party_m_test

(PARTY_C is the field name, PARTY_M is the table name)

I have 26 more sql like this.

Can someone help me with a faster way to improve performance?

Thanks.

Report message to a moderator

Re: IMPROVE PERFORMANCE WHEN INSERT RECORDS [message #305493 is a reply to message #305485] Tue, 11 March 2008 00:42 Go to previous messageGo to next message
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Take a look at this page.
Ross Leishman

Report message to a moderator

Re: IMPROVE PERFORMANCE WHEN INSERT RECORDS [message #305503 is a reply to message #305493] Tue, 11 March 2008 01:42 Go to previous message
curlybird
Messages: 2
Registered: March 2008
Junior Member
Hi Leishman,

Thanks so much for your help.

I still try.

Will let you know when have result.

Report message to a moderator

Previous Topic: cost in explain plan
Next Topic: Statspack
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jun 27 21:02:14 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.