Subject Small Database with very very bad performance on LAN
Author Luigi Siciliano
Hallo,
I have a small database (less 100MB) that works on Firebird 2.5.5
SS64bit over a machine with Win7 64bit with 4GB Ram, CPU Pentium G620.

I seems to work very well in local but with the 3 clients on LAN works
very bad. It is very very slow to open and navigate a simple table with
less of 5.000 rows!

What i can do?

I very novice in Firebird.

The result of gstat is:
Database header page information:
Flags 0
Checksum 12345
Generation 26613
Page size 4096
ODS version 11.2
Oldest transaction 26603
Oldest active 26604
Oldest snapshot 26604
Next transaction 26605
Bumped transaction 1
Sequence number 0
Next attachment ID 139
Implementation ID 26
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Jan 4, 2016 15:44:10
Attributes force write

Variable header data:
Sweep interval: 20000
*END*

Thanks

--

Luigi Siciliano
--------------------------