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