Re: Performance of SQL db via the Internet?

Lars,

Is your performance "ok" because of the number of records in your db or because of slow/conjested bandwidth? Do you notice much of a difference between ISDN and 28.8 modem access? Are your 60 ISDN users going through an ISDN router or are they connectly indivdually through ISDN adaptors to the internet?

Steven Hill

>
> I don't know if this can help you, but i give it a try...
>
> Since 1994 we have a system running in clients interacting whita a Oracle server. The clients
> are developed in SQLWindows(Centura Software, former Gupta). We use SQL * Net and TCP/IP.
> We have customers using ISDN,INTERNET and Internet access via modem-pools(TELE2, Sweden). There
> are more than 50-100 users which access tha database via internet and about 60 via ISDN.
> The performance is ok but can offcause be improved.
>
> Regards/Lars-Erik
>
> In article <32FFB82F.5498_at_compcat.com>, steven_at_compcat.com says...
> >
> >Does anybody have experience connecting directly (ie, not via a web
> >server) to a SQL database over the Internet via TCP/IP?
> >
> >How reliable is the connection? How did/do you connect to it (ie, ISDN,
> >modem/speed etc.)? I'm aware of the internet's congestion at times;
> >however, I'm looking for some opinions on connection stability, lost
> >packets, performance in general.
> >
> >What is the performance like (please provide an example)? Is it
> >reasonable to expect that in 6-12 months time, using the Internet as a
> >network backbone will be a viable alternative to leased lines,
> >frame-relay etc in a scenario where 50-100 users a connected to an SQL
> >server via the Internet.
> >
> >Thanks for your opinion.
> >
> >Steven Hill
 

-- 
Steven Hill                 
Computer Catalyst, Inc.
mailto:steven_at_compcat.com