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 пользователь "[email protected]" < [email protected]> написал: > ** > > > ** 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: [email protected] > Do: <[email protected]> > 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 > >
