Subject | Re: [firebird-support] Configuring Firebird for high transaction through put |
---|---|
Author | Thomas Steinmaurer |
Post date | 2014-10-29T18:45:45Z |
> Run stadistic for databaseresources and even with a 16K page size you may reach that threshold
> - 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
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.