Subject Re: Slow connection establishment with .NET and Firebird
Author rcn_listas
Hi Daniel!!

Follow my answers:

OS: Windows Vista Ultimate
Firebird: 2.0
DB File extension: .fdb
RAM: 2 Gb.

I did not check my firewall. It is a Mcafee firewall. I will try if some configuration about this is avaiable and then I let you know. But I also noticed that in a machine where is running Avast with Windows Vista Firewall.

Thank you!

Rafael

--- In firebird-support@yahoogroups.com, Daniel Rail <daniel@...> wrote:
>
> Hi,
>
> At Monday, April 20, 2009, 11:25 AM, RCN Listas wrote:
>
> > I having a such boring situation that i don't know how to solve. I have a
> > .NET application using FirebirdSQL Client (.Net Provider). When I run my
> > application it takes too long to establish the connection with my DB. It
> > takes almost 2 or 3 seconds and my DB is local. Does anyone knows why?
>
> What is the OS? Which version of Firebird that you are using? What
> is the database file's extension? If the extension is .GDB, then
> rename it to something else(i.e.: .FDB) . Is it possible that your
> firewall(connection) or antivirus(reading/writing the DB file) might
> be slowing down the process? The anitivirus effect can be noticeable
> if the DB file is large enough, and this depends on your system
> configuration. Also, how much memory is available when running the
> application?
>
> --
> Best regards,
> Daniel Rail
> Senior Software Developer
> ACCRA Solutions Inc. (www.accra.ca)
> ACCRA Med Software Inc. (www.filopto.com)
>