> 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.

Run gstat -h against the database when things are getting slow.


--
With regards,
Thomas Steinmaurer
http://www.upscene.com/

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.