| Subject | Re: Odp: [firebird-support] Decrease disk IO |
|---|---|
| Author | Alexey Kovyazin (ak) |
| Post date | 2013-09-19T05:27:33Z |
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.
Regards,
Alexey Kovyazin
IBSurgeon
19.09.2013 9:20 пользователь "liviuslivius@..." <liviuslivius@...> написал:
Hi,
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
Regards,
Karol Bieniaszewski
----- Reply message -----
Od: sopranoeli@...
Do: <firebird-support@yahoogroups.com>
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)
Thanks!
Vanina