Subject | Small Database with very very bad performance on LAN |
---|---|
Author | Luigi Siciliano |
Post date | 2016-01-08T11:50:26Z |
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
--------------------------
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
--------------------------