Bergquist, Brett wrote:
Also after testing we are seeing the following. With a database with no deleted rows, my test application is inserting about 150 records/second into a table. I let this run for about 2 million records and the insert rate is consistent. Now I purge out 1.5 million records and run the test again. The insert rate is now about 25 records/second. Running the above compress with the PURGE_ROWS option and rerun the test and still about 25 records/second. Run full SYSCS_UTIL.SYSCS_COMPRESS_TABLE and rerun the test and the insert rate is back to 150 records/second.
Both of these insert rates seem really slow. I am going to guess that you do one commit per insert, is that right?
