Hi, I have a database which is written extensively 7x24. The "select" queries become very slow when there are too many write transactions. How can I improve the query speed? Increase cache size? Use certain isolation / lock resolution mode for query transaction so it won't be blocked by write transaction? Split the database into multiple files?
I know index is of the most important. I will try to optimized it but still wondering if there is other thing to adjust. BTW, when the system is not loaded, the query is fast. I am using FB 1.5.4 and ADO.NET provider 2.0.1. The select doesn't have explicit transaction. I suppose it's using the default IsolationLevel.ReadUncommitted ? Thanks! 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
