| Subject | Re: [firebird-support] Firebird configuration for better performance |
|---|---|
| Author | |
| Post date | 2014-01-09T10:15:47Z |
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.
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 moderate workload (INSERTS, UPDATES and SELECTS) throughout the day. The database is currently empty (we're just starting out) and the size currently stands at about 6 MB and is due to grow as data and transactions are added.
To increase performance, I've changed the default Firebird memory settings as thus:
For the database (Using GBAK restore with options):
Page Size = 8192
Buffers = 32768
In the firebird.conf file:
DefaultDBCachePages = 32768
Can anybody here explain to me:
1) Whether the given PC specification (RAM) will support this database?
2) Is this a good configuration? If not what are the ideal values I should adjust to?
Thanks in advance for any enlightenment.
Regards,
Steve Faleiro