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 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 > >
