Subject | Re: Slow Connection From Server |
---|---|
Author | jamesconnorjr |
Post date | 2005-05-27T13:10:59Z |
Well I must apologize for 1) not being clearer about the situation,
next time I will make sure to provide the necessary information and
2) giving incentive, but I'm new to using this group and not aware
of the rules. I usually go through forums and know that kind of
thing happens sometimes.
Anyhow, after midnight we finally figured out what the issue was.
The OS we were using was Windows 2003 server and what I met by
copied was exactly that, I cut and paste the db from my laptop to
the server. I thought I specified a comparison of the log in time.
It took about five seconds before to log in and get running and then
when we experienced the problems, it took thirty seconds to log in
and about thirty seconds per db transaction. I meant by locally
meaning on my laptop not connected to the network compared to the
server when connected to the network.
And in that lied the problem. We moved the app and copy of the
firebird db to a private netork and that resolved it. As we found
out this morning, the port we were using was being blocked without
our knowledge. So now we had to move everything to a private network
until the state has their issue resolved. Thanks for the help and
responses.
And Helen, we have made donations and will keep them coming.
--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:
next time I will make sure to provide the necessary information and
2) giving incentive, but I'm new to using this group and not aware
of the rules. I usually go through forums and know that kind of
thing happens sometimes.
Anyhow, after midnight we finally figured out what the issue was.
The OS we were using was Windows 2003 server and what I met by
copied was exactly that, I cut and paste the db from my laptop to
the server. I thought I specified a comparison of the log in time.
It took about five seconds before to log in and get running and then
when we experienced the problems, it took thirty seconds to log in
and about thirty seconds per db transaction. I meant by locally
meaning on my laptop not connected to the network compared to the
server when connected to the network.
And in that lied the problem. We moved the app and copy of the
firebird db to a private netork and that resolved it. As we found
out this morning, the port we were using was being blocked without
our knowledge. So now we had to move everything to a private network
until the state has their issue resolved. Thanks for the help and
responses.
And Helen, we have made donations and will keep them coming.
--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:
> OK, Jimmy. you've been up all night and you're not even thinkingstraight
> enough to provide the BASICS of a problem description.breaths
>
> Stick your head out the door and inhale some fresh air in deep
> until you begin to see stars. Then eat a raw apple. And thenanswer some
> questions.and
>
> At 10:57 PM 26/05/2005 +0000, you wrote:
> >Huge problem. I have installed firebird onto the client's server
> >it has been working.is the
>
> What OS? (OS = "Operating System"). If it is Windows, what
> version? service pack? If it is Windows XP or Server 2003, what
> full name of the database file?you did
>
> >Until this morning when I converted some data for
> >the client and copied the updated db onto the server.
>
> Let's be clear what you mean by "copied". Describe precisely what
> to perform this "copy" operation.connects to
>
>
> >Now the app runs extremely slow. I know it happens when it
> >the db from my tests.example to
>
> RUNS more slowly than before?
>
> Or it takes a client longer to connect than before?
>
> Or both?
>
> >Other thing is that when I run it locally it runs fine. For
> >sign onto the system it takes five seconds locally but thirtyseconds when
> >running through the server.locally"
>
> This is totally meaningless. What do you actually MEAN by "run it
> and "running through the server"? Please explain what you mean byboth of
> these expressions.as both
>
> >I've tried everything that I know of from reinstalling firebird
> >classicwas
> >and super server
>
> So - what model of server do you have installed now? What model
> installed before? In both (all) cases, what VERSION of Firebird?Have
> you, for example, been swapping between Fb 1.0 and 1.5 andignoring the
> client libraries?know
>
> >and copying the db on another machine on the network
>
> What kind of copying?
>
>
> >and changing the ip address of the connection string
>
> So - you are using the IP address in connection strings? Do you
> whether your client's network is using dynamic IP addressing? Thedon't
> safe-play thing to do when deploying anything to a network you
> control yourself is to anchor the server's IP address and make itstatic,
> by insisting that a HOSTS entry is created at the server AND thethe
> clients. Have your applications and tools applications alike use
> server name for connecting.help.
>
> >, to changing out network cards. Still nothing. Please, please
>work with.
> Please, please help YOURSELF by providing information that we can
>you're
> Oh, and, btw, when we finally get to the bottom of your problem,
> welcome to show your gratitude by making a donation to theFirebird
> Foundation. It is not cool to offer financial incentives on thislist.
>
> ^heLen