Subject | connection performance |
---|---|
Author | Paresh Dhakan |
Post date | 2005-03-01T18:40:05Z |
Hi !
I am using Firebird SuperServer 1.5.0.4290-0.i686 on RH8 and connecting to it from Windows 2000 clients (.NET application using Firebird.NET version 1.0). At times it takes more then 40 seconds to connect (connection.BeginTransaction() to be specific). I am not sure if it is the server which is taking time or .NET provider. Even connecting to the database from FlameRobin or isql takes lot of time.
Once connected, the performance is sometimes slow, sometimes ok. I have indices on tables where needed.
Any ideas where the problem is?
Thanks,
Paresh
[Non-text portions of this message have been removed]
I am using Firebird SuperServer 1.5.0.4290-0.i686 on RH8 and connecting to it from Windows 2000 clients (.NET application using Firebird.NET version 1.0). At times it takes more then 40 seconds to connect (connection.BeginTransaction() to be specific). I am not sure if it is the server which is taking time or .NET provider. Even connecting to the database from FlameRobin or isql takes lot of time.
Once connected, the performance is sometimes slow, sometimes ok. I have indices on tables where needed.
Any ideas where the problem is?
Thanks,
Paresh
[Non-text portions of this message have been removed]