Subject | slow commit |
---|---|
Author | Heiko Tappe |
Post date | 2003-04-17T10:02:45Z |
Some time ago I already mentioned this problem here.
Now I have some more information.
The problem: the time to commit some data (maybe 20 records) is quite long.
It differs between 0.4 s and 1.0 s (sometimes even longer).
(Running db-server on w2k)
Some network analysis with Ethereal showed 2 commits: one is fast, the other
one's slow.
Fast (0.02s):
Request commit
Reply response
Slow(0.4s):
Request commit
gds_db > 1121 [ACK]
Reply response
1121 > gds_db [ACK]
And so I found out, that the same server-version with the same database
commits
in acceptable time (0.02s) if I run it on the same w2k-machine (with
localhost:<database>).
So maybe a network problem?
Can I work around this?
-- Heiko
Now I have some more information.
The problem: the time to commit some data (maybe 20 records) is quite long.
It differs between 0.4 s and 1.0 s (sometimes even longer).
(Running db-server on w2k)
Some network analysis with Ethereal showed 2 commits: one is fast, the other
one's slow.
Fast (0.02s):
Request commit
Reply response
Slow(0.4s):
Request commit
gds_db > 1121 [ACK]
Reply response
1121 > gds_db [ACK]
And so I found out, that the same server-version with the same database
commits
in acceptable time (0.02s) if I run it on the same w2k-machine (with
localhost:<database>).
So maybe a network problem?
Can I work around this?
-- Heiko