Re: Online 5 using TCP/IP and SLIP/PPP

Posted in 1995

Topics: Stored Procedures & SPL, Connectivity: ODBC / JDBC / .NET, Networking & sqlhosts Configuration

Dominic Pratt — 1 Dec 1995 10:48:05 -0500 — source: Informix-list mailing list archive (1991-1998)

At 08:20 pm 30/11/95 GMT, you wrote: >Has anyone had any experience, good or bad, using TCP/IP and SLIP/PPP to >connect to an Online engine. We want to use a Windows front end, probably >NewEra, to connect to an Online 5 engine but need to allow for some users >to use dial up connections. > >We're told that > >a) its a hard thing to do It is very easy to do - in my case I switched out the windows winsock.dll file and replaced it with the Trumpet version that supports SLIP/PPP. >b) it runs slowly Here are some timings showing the difference in response using PPP connection via a 14,400bps modem against a LAN connection. Server: Informix SE running on a 486 16mb under sco unix Client: 486 16mb windows for work groups / trumpet tcp/ip / SQL Retriever ODBC connection / Access 2.0 I attached a microsoft access table to an informix table and opened the table and read all the records. The table contains 2 integer columns and 112 records. Open table and display 1st 25 records - 1 second on LAN, 13 seconds on PPP Read all records on table - 3 seconds and 64 seconds subsequent reads of entire record set - 2.5 seconds and 40 seconds > and erratically > seemed pretty stable to me. Dominic Pratt