ActiveX control accessing db is slow when line is down

------=_NextPart_000_0003_01C50841.5ACABE20
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

We have an ActiveX control in our web app directly accessing our MySQL =
database on a windows server on port 20101.

Our gateway/dns server is on a Linux server on our network.

We have a permanent internet line, but whenever our internet line is =
down, the ActiveX control takes ages to display any data, its like there =
is a huge pause and then eventually data displays.

Why would this be?

Thanks


------=_NextPart_000_0003_01C50841.5ACABE20--

Re: ActiveX control accessing db is slow when line is down

Hi,

Greg Quinn wrote:
> We have an ActiveX control in our web app directly accessing our MySQL database on a windows server on port 20101.
>
> Our gateway/dns server is on a Linux server on our network.
>
> We have a permanent internet line, but whenever our internet line is down, the ActiveX control takes ages to display any data, its like there is a huge pause and then eventually data displays.
>
> Why would this be?
>
The control waits for time-outs before it continues?

Erich

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: ActiveX control accessing db is slow when line is down

A dumb question...
Are you acessing the server (MySQL) using its name or IP?
Your gateway may be trying to get DNS for your name outside (dus
giving you lag) and after that (timeout as Erich said) its giving you
the IP.
Or, if you're using IP, maybe a firewall/router/proxy configuration issue...

Ok, after the tech info, a personal experience, I had this server,
working with no firewall on my LAN, and while the client tries to
access the server, a lag of 20 to 30 seconds for the first conn to
open was normal (and unaceptable), after some time, I noticed that
that the client machine had a modem, and IPX, TCP protocols for the
modem (plus Windows bs, a lot of it) after disabling the modem and
cleaning the protocol list, the new lag was 0.5 s. Cleaning the server
protocols too gave me less lag on local operations with large ammount
of data.

On Tue, 01 Feb 2005 17:58:33 +0800, Erich Dollansky
wrote:
> Hi,
>
> Greg Quinn wrote:
> > We have an ActiveX control in our web app directly accessing our MySQL database on a windows server on port 20101.
> >
> > Our gateway/dns server is on a Linux server on our network.
> >
> > We have a permanent internet line, but whenever our internet line is down, the ActiveX control takes ages to display any data, its like there is a huge pause and then eventually data displays.
> >
> > Why would this be?
> >
> The control waits for time-outs before it continues?
>
> Erich
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=danieldaveiga@gmail.com
>
>


--
Daniel da Veiga
Computer Operator - RS - Brazil

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org