Re: [firebird-support] Firebird configuration for better performance

2014-01-09 Thread fabianoaspro
Change your fb to Classic or Superclassic so you can use all cpu cores. If you choose Classic you also need to increase hashmemslots by 10 times at least (prime number). Google for it. Em 08/01/2014 22:39, stevef...@yahoo.com escreveu: Hi, I'm running Firebird 2.5.2 SuperServer on a Windows

[firebird-support] Firebird configuration for better performance

2014-01-08 Thread stevef199
Hi, I'm running Firebird 2.5.2 SuperServer on a Windows 7 Professional 64-bit PC. The PC currently has 4 GB of RAM, but we plan to upgrade to 8 GB soon. The database is a small database used for inventory and stock control with about 30 tables, with about 6 - 8 concurrent users, and relatively

Re: [firebird-support] Firebird configuration for better performance

2014-01-08 Thread Alexey Kovyazin
Hi Steve, This database is very small, you should not have any performance problems (except related with lack of indices or bad design of metadata). Usually we recommend to set 1 buffers for SuperServer - our experiments have shown that 1 is the best # of buffers for SuperServer.