Subject | Very slow StartTransaction |
---|---|
Author | tdtappe |
Post date | 2007-06-25T06:35:54Z |
Does anybody know what can cause a StartTransaction to take more than
55 seconds (yes, seconds - not milliseconds!)?
I tried with FB 2.0 SS (XP) and CS (Linux). The problem is
reproducable with one specific database (dialect 1). But only with our
complex application. I couldn't create a simple test case so far and I
doubt I will manage to create one :-(
I also checked a freshly restored database. Same problem.
And I tracked down the problem to the API call (isc_start_multiple).
This is the one that lasts that long.
Any ideas?
--Heiko
55 seconds (yes, seconds - not milliseconds!)?
I tried with FB 2.0 SS (XP) and CS (Linux). The problem is
reproducable with one specific database (dialect 1). But only with our
complex application. I couldn't create a simple test case so far and I
doubt I will manage to create one :-(
I also checked a freshly restored database. Same problem.
And I tracked down the problem to the API call (isc_start_multiple).
This is the one that lasts that long.
Any ideas?
--Heiko