Subject Re: Odp: [firebird-support] Decrease disk IO
Author Alexey Kovyazin (ak)

Hi Karol,

According to your advice, there should be no database which work fast and wity size greater than RAM. :)
Your answer is incorrect.

Correct advice will be: analyze statistics for queries and optimize them with indices or rewriting.

Alexey Kovyazin

19.09.2013 9:20 пользователь "liviuslivius@..." <liviuslivius@...> написал:


You need RAM size>=db file size + 2 GB for system. And then you must configure defoultdbcache size in fb config to value >=dbfilesizeInBytes/dbpagesizeInBytes

Karol Bieniaszewski

----- Reply message -----
Od: sopranoeli@...
Do: <>
Temat: [firebird-support] Decrease disk IO
Data: czw., wrz 19, 2013 02:19


Hello everybody!
I'm running Firebird SuperServer 2.5 at Debian. My disk is HDD and some times fbserver process waiting for IO at 99%!
How can I decrease disk IO? (other than buying SSD disk)