| Subject | RE: [firebird-support] Re: Problems with connections |
|---|---|
| Author | Maya McLeod |
| Post date | 2004-03-16T09:34:26Z |
Hi Yoli,
We had the same problem when we 'upgraded' our server to 2003.
We tried every suggestion out there, from renaming GDB files to FDB, to
disabling any kind of automatic system backup/restore (which is not at all
the same as XP), to configuring for Apps, rather than services, to checking
all the security settings, and TCP IP filters, and disabling any security
setting that we thought we could do without.
Occasionally we would get a decent connect speed, but the next try resulted
in it being just as slow as before (and I'm talking too slow to actually
work with, as the 2003 server runs our in-house programs). Waiting 30
seconds or so to open a very small DB App was affecting our working speed
dramatically.
We changed over to FB1.5, even though we are using a rather old version of
IBX controls, and all our speed issues disappeared, and everything is
working lightening fast again.
We have been running since last saturday, and done some additional testing,
but have so far not found any problems.
It will be interesting to know if you DO manage to find a work around that
makes a real difference, but you might find that going over to FB1.5 is
going to be the easiest solution.
Regards
Maya
-----Original Message-----
From: yolisqlmax [mailto:y.herrero@...]
Sent: 16 March 2004 11:19
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: Problems with connections
We don't use disk shadowing.
We only have one hard disk.
Do you have more ideas?
Thanks!
--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
wrote:
We had the same problem when we 'upgraded' our server to 2003.
We tried every suggestion out there, from renaming GDB files to FDB, to
disabling any kind of automatic system backup/restore (which is not at all
the same as XP), to configuring for Apps, rather than services, to checking
all the security settings, and TCP IP filters, and disabling any security
setting that we thought we could do without.
Occasionally we would get a decent connect speed, but the next try resulted
in it being just as slow as before (and I'm talking too slow to actually
work with, as the 2003 server runs our in-house programs). Waiting 30
seconds or so to open a very small DB App was affecting our working speed
dramatically.
We changed over to FB1.5, even though we are using a rather old version of
IBX controls, and all our speed issues disappeared, and everything is
working lightening fast again.
We have been running since last saturday, and done some additional testing,
but have so far not found any problems.
It will be interesting to know if you DO manage to find a work around that
makes a real difference, but you might find that going over to FB1.5 is
going to be the easiest solution.
Regards
Maya
-----Original Message-----
From: yolisqlmax [mailto:y.herrero@...]
Sent: 16 March 2004 11:19
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: Problems with connections
We don't use disk shadowing.
We only have one hard disk.
Do you have more ideas?
Thanks!
--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
wrote:
> > Hello!to
> >
> > I have a problem with my connection to my Firebird databases.
> >
> > I'm using Firebird 1.0.3 with Windows 2003. If I try to connect
> > firebird using IBManager 3.0, it takes 20 - 25 seconds to makethe
> > connection. After this, the queries are not as slow as theconfigure
> > connection.
> >
> > Do you have any idea about what is happening? Do I have to
> > something?Yahoo! Groups Links
> >
> > Thanks in advance.
> >
> > Regards.
> > Yoli.
>
> if you have disk shadowing turned on - then turn it off
> Alan