Subject Re: [firebird-support] Configuring Firebird for high transaction through put
Author Thomas Steinmaurer
> Run stadistic for database
> - Look for index in de big tables. Look for Depth > 2. In this case
> up Page size one step, and run database statistical.

>2 is quite conservative these days with the available hardware
resources and even with a 16K page size you may reach that threshold
with indexes on moderate sized tables rather quickly. Everything <=3 is
just fine.


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

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