Re: Informix WAN performance compared to SQL and Oracle
On Thu, 16 Nov 2000 kbadinger@my-deja.com wrote: > We have a software product which backend 3 different databases; > Informix, SQL Server and Oracle. Our customers run these products over > both WAN and LAN environments. We use odbc to connect to these > databases. One obvious question is whether these customers use the same type of WAN. For example there may be customers who have a T1 or multiple T1's or even gigabit ethernet links ... (they may simply use different wan technologies). The Informix users may have just a 128 Kilobit line while the SQL Server users may have a faster link. =20 > We are experiencing severe performance degradation of the application > when back ended by Informix. A few of our Informix customers have > escalated these issues and are demanding we solve them. We setup a > controlled lab environment to test this problem. We have loaded the > same customer dataset into all 3 platforms. Specifically these are; > Informix 7.31.TC4, SQL Server 7.0, and Oracle 8.0. We are using the > following ODBC drivers; Informix 2.80 driver, SQL Server 3.70, and > Oracle 8.00. Both the client and the database server are running > Windows NT 4.0 sp4. >=20 > We are fetching a total of 18,000 rows from the database, ranging in > fetch from 1 row to 5000 rows at a time. Running this process over a > LAN, the following results were found: > Informix=09Oracle SQL Server > 34097 ms=0933456 ms=0942509 ms >=20 >=20 > Running this process over the WAN, the following results were found: > Informix=09Oracle=09 SQL Server > 339093 ms=0978042 ms=0966164 ms >=20 > Consistently, Informix performance over the WAN has been 4-5 times > slower than Oracle, and 5-6 times slower than SQL Server. >=20 > There are 4 hops to the server over the WAN. >=20 > I have attempted to tune the fet_buf_size environment variable, and I > have added the =96b 4096 variable to the server startup. Neither of > these has made a significant positive effect. >=20 > My questions are: > 1.=09Is Informix performance in a WAN/ODBC environment simply > constrained to being slower than Oracle and SQL in that > environment. > 2.=09If not, what variables need to be tuned to improve performance > for Informix in that environment. >=20 > Please let me know if there is any additional information that I can > provide to help resolve this problem. >=20 > Any help would be greatly appreciated. >=20 > Thanks, > Kevin Badinger >=20 >=20 > Sent via Deja.com http://www.deja.com/ > Before you buy. >=20