Hi there, I have a server which is heavily loaded 7x24. Sometimes it can be a hundred threads (trying) writing into the database. After running the server for 3~4 days, the database grows to 800MB or so, then I got exceptions of "FirebirdSql.Data.FirebirdClient.FbException: I/O error for file CreateFile (open) "tmcdb.fdb" Error while trying to open file" for all following DB operations. By examining the database I found a checksum error.
My feeling is that the big amount of connection may cause database corruption. I wildly set the connection pool size to 1000, basically pool all connections. My question is, shall I reduce the connection pool size to limit the amount of simultaneous transactions? what size shall I use, 20, 50, 100, etc? Thanks a lot! Sean ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
