Commit performance

[Lance Norskog]

How long should a <commit> take? I've got about 9.8G of data for 9M of
records. (Yes, I'm indexing too much data.) My commits are taking 20-30
seconds. Since other people set the autocommit to 1 second, I'm guessing we
have a major mistake somewhere in our configurations.
 
We have a lot of deletes/re-adds to commit. Any hints?
 
Thanks,
 
Lance