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

2014-01-09 Thread stevef199
Hi Alexey, For the database (Using GBAK restore with options): Page Size = 8192 Buffers = 1 In the firebird.conf file: DefaultDBCachePages = 32768 Is this okay? Bests, Steve

[firebird-support] RE: SQL error code = -104 Unexpected end of command, from Delphi App

2014-01-08 Thread stevef199
Try 'Append' instead of 'Insert'

[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