Re: How to tune insert opreation performance?

From: Michael <michael.lohmar_at_gmail.com>
Date: 22 Dec 2004 05:15:10 -0800
Message-ID: <1103721310.598627.305450@f14g2000cwb.googlegroups.com>

Hello Pankej,

> how to tune the insert opreation performance...

Hm ... Where is your problem with your insert operations?

In general it depend on the count of indices you have created on your table, trigger which are maybe fired during the insert, a bad space management for this table and/or what is often a problem ... on a wrong setting of the inittrans value for this table. Many time a slow insert operation is forced due to concurrent inserts which do block each other. Not to forget I/O bottlenecks of the system and concurrent read/writes on the same disk.

As you can see there are a lot of reasons and I'm sure I forgot about to mention a few in my list ...
Maybe you should ask a little bit more concrete.

Greetings,
Michael Received on Wed Dec 22 2004 - 07:15:10 CST