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

Reply via email to