All, As I said before, ext4 performance with FW=ON is much slower than ext3, but I now found something new.
I've verified that with FB 2.5, TCS times was ok (0s - 3s), and only with FB 3 they are very bad (first test takes 16s, then 12s, 8s, 7s, 7s, etc) What I found is that: Times was bad only with the default SharedCache=true. It happens because in this condition, both the cache_writer and garbage_collector calls PAG_init and it then sets FW=ON before the database is completely created! In FB 2.5, only running CREATE DATABASE does not even open it as forced write. It's just after some other command calling PAG_init that it happens. So now we're spending time while the database is not even completely created. Adriano ------------------------------------------------------------------------------ 10 Tips for Better Server Consolidation Server virtualization is being driven by many needs. But none more important than the need to reduce IT complexity while improving strategic productivity. Learn More! http://www.accelacomm.com/jaw/sdnl/114/51507609/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel