Re: Very slow ODBC connections?

Mats What OS are you running IDS on? If it is NT, how many users are in the Domain user table? When sitting on the database server, how long does a "dbaccess databasename" take? Do you have a network issue causing a timeout between the application machine or database machine? - (telnet from application onto the database server? Murray Wood ----- Original Message ----- From: Mats Gefvert <mats.gefvert@jak.se.remove-this-part> To: <informix-list@iiug.org> Sent: Sunday, 22 August, 1999 02:46 Subject: Very slow ODBC connections? > Hi, > > I'm designing a few applications where I connect to our Informix 7.23 > database server using the Newera Informix7 ODBC driver. So the way I do it > of course is to just snap in a TDatabase object in C++Builder 3 and set the > AliasName to the ODBC datasource name. > > My problem is that it takes roughly 20 to 25 seconds to connect to the > database. This is the same using all kinds of applications, specifically > Borland C++Builder, Database Explorer and my own applications. Opening the > database with Excel takes similar amounts of time, or somewhat shorter, but > still a very long time. Ilogin Demo also takes 15+ seconds. > > Does anyone have any idea what's going on? Does the BDE or the ODBC slow > things down considerably compared to Informix native connections? One thing > I'm also curious about: When I use a prepared sql INSERT INTO statement I > get a throughput of 30 inserts per second. I'm used to seeing Paradox > import 1000's of rows every second... Am I just wrong or what's happening? > Our Informix server is a big fat Pentium thing with 256 MB of memory and it > just screams, and with hardly any utilization noticeable, apart from when > you do imports and exports, when utilization soars to 100%. > > Hoping for help, > Mats Gefvert > JAK Membership Bank, Sweden > >

> What OS are you running IDS on? NT 4 with SP4 > If it is NT, how many users are in the Domain user table? About 7. > When sitting on the database server, how long does a "dbaccess databasename" > take? Barely noticable. Roughly 5 seconds on a 100% load server (just tried). > Do you have a network issue causing a timeout between the application > machine or database machine? - (telnet from application onto the database > server? Not that I have noticed. We're of course using pcAnywhere to connect to it, but not that I know of, no. Mats Gefvert <mats.gefvert@jak.se> JAK Membership Bank