Unanswered: insert is slower when DataFile size increases
I have a noticed the following behavior...
when the DB is clean and fresh... our DB handles a very high rate of inserts (~1200 per second), butwith time, when the datafile (think thats the reason but might be any other thing... maybe indexes?) increases - the rate is going down. Right now the rate of inserts per second is around 500 per second (around 40% from the starting rate).
Does anyone has any idea why is that happen? How can I solve that problem?
Thanks for the fast reply...
but in both cases my answer will be negative...
I insert the data with regular insert - no ordering.
There is no reorg on the object
once in a while (user request) there is a query to get info from table, but even without it the rate is going down...