Subject Firebird performance decrease over continuos inserts/updates
Author Alfonso Presa

I'm doing a batch insert/updateon 2 tableswith around 1.2 millions records. After some time performance decreace drastically. I'm using that DB for Web reporting using VS2010 and the appication wich do the batch insert/update is in Delphi with FIBPlus.

The server is i5 64 bits with 4GB RAM but when the server gets slow it is not due to resource lacking because memory and cpu on Task Manager is below 30%. I'm using Superserver v 2.5.2.

Any idea should be appreciated.



[Non-text portions of this message have been removed]