[Firebird-test] Open and Close connection to Firebird 1.03 972 server is slow in Windows XP

[Chau C. Y. <cc...@es...>]

Dear All,

I found a problem with Firebird 1.03 972 windows version.  I hope 
someone may help.

The problem is the Open and Close connection to Firebird 1.03 server is 
slow in some situations. 

I use Delphi to write a simple test case to Open / Close repeatedly:


Access database locally:
========================

procedure TForm1.Button1Click(Sender: TObject);
var i: integer;
    d1, d2: integer;
begin
  IBDatabase1.DatabaseName := 'c:\test.fdb';
  for i := 1 to 10 do begin
    IBDatabase1.Open;
    IBDatabase1.Close;
  end;
end;

The above procedures show the results:

             IB 6         FB 1.03(972)       FB 1.5.1

Win98        Fast             Fast             Fast
WinXP        Fast             Fast             Fast



Access database using TCP:
==========================

procedure TForm1.Button1Click(Sender: TObject);
var i: integer;
    d1, d2: integer;
begin
  IBDatabase1.DatabaseName := 'localhost:c:\test.fdb';
  for i := 1 to 10 do begin
    IBDatabase1.Open;
    IBDatabase1.Close;
  end;
end;


The above procedures show the results:

             IB 6         FB 1.03(972)       FB 1.5.1

Win98        Fast             Fast             Fast
WinXP        Fast          -> Slow <-          Fast


I suspect it could be the Firebird 1.03 972 's problem.  It shows slow 
performance over TCP connection in Windows XP.

I don't think it is machine's problem or TCP/IP network problem as 
implicated from the above result.  If you use IB Console to repeatedly 
open/Close database running on Firebird 1.03 972 windows xp, you can 
feel the some pause as well.

Since my application still running on Firebird 1.03, I couldn't upgrade 
to Firebird 1.5 at the moment.  Could anyone please give me some 
advice?  I suspect it is the compilation problem in Firebird 1.03 972 
release.

-- 
Best regards,
Chau Chee Yang

E Stream Software Sdn Bhd
URL: www.sql.com.my
SQL Financial Accounting