RE: [RadiusNT] External Access Slow

wilson@dagupan.com
Mon, 7 Feb 2000 08:29:48 +0800

you may want to open a 'project' in access 2000. The way i understand it,
its access frontend to sql database backend. I have done some experiments
with it via 33.6 dialup and it works okay for a 200mb database.

> -----Original Message-----
> From: Michael Saunders [mailto:mick@tsn.cc]
> Sent: Monday, February 07, 2000 3:53 AM
> To: radiusnt@iea-software.com
> Subject: Re: [RadiusNT] External Access Slow
>
>
> The problem with using access for you database access
> remotely. Is that
> every time it runs a query it has to pull a copy of the table
> down local so
> as to work with it. I would suggest using sql as everything
> is done on the
> server side and only the records required are returned.
>
> I have also access 2000 now has the sql server engine built
> into it. It may
> be worth while giving it a go
>
> Michael Saunders
> ----- Original Message -----
> From: "Edsonet" <administrator@yellowhead.com>
> To: <radiusnt@iea-software.com>
> Sent: Monday, February 07, 2000 5:10 AM
> Subject: [RadiusNT] External Access Slow
>
>
> > I don't think this is a RadiusNT problem, but it involves
> external access
> > to the Radius database. To make a long story as short as
> possible, this is
> > the sequence of events: (We are running RadiusNT 2.5 using
> Access database
> > on NT 4.0 SP3)
> > - I added SNMP service to the server some time ago, but did
> not reboot the
> > server because I did not want to shut down Radius.
> > - For some unknown reason the server decided to reboot one
> day, and of
> > course it would not reboot properly because the Service
> Pack had to be
> > reinstalled. When it couldn't find INETMIB1.DLL, it would
> not load TCP/IP
> > properly.
> > - Once we noticed it was down, the service pack was
> reinstalled and the
> > server restarted.
> > - The database was corrupted, so we had to load a backup
> copy and bring it
> > up to date.
> >
> > So far everything sounds normal, and RadiusNT seems to be
> operating OK.
> The
> > problem we have now is that any external access to the
> database is very
> > slow, and we don't have a clue why. It is so slow that in
> some cases our
> > programs time out waiting for a response. Any ideas out there?
> >
> > J.A. Coutts
> > Systems Engineer
> > Edsonet/TravPro
> > administrator@yellowhead.com
> >
> >
> > For more information about this list (including removal) go to:
> > http://www.iea-software.com/support/maillists/liststart
>
>
> For more information about this list (including removal) go to:
> http://www.iea-software.com/support/maillists/liststart
>

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart