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.
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: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Take a look at this page.

Ross Leishman
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.
Previous Topic: cost in explain plan
Next Topic: Statspack
Goto Forum:
  


Current Time: Sun Dec 04 19:09:06 CST 2016

Total time taken to generate the page: 0.03957 seconds