Re: ODBC

Posted in 1995

Topics: Performance & Tuning, Connectivity: ODBC / JDBC / .NET

Thomas Nimstad — Sun, 02 Apr 1995 11:29:26 +0100 — source: Informix-list mailing list archive (1991-1998)

>> We're about to start a new project, and we're interested in ODBC. >> Performance is, of course, high on our list of concerns. Rumor has it >> that ODBC is pretty slow when compared to vendor specific connections. > We have a BAD expierence with ODBC. The Form recognition software stores > the data on-line. The result of the implementation was very slow. We are > recognizing at speed of approximatly 50-100 forms per minute. When trying > using ODBC the speed was reduced down to one page per minute. And what ENGINE did you use ? ODBC is a transport layer, not a database ! We in our system are handling aprox one transact per second using ODBC to SQL Server 4.21 and the total size of the database is 1 GB. // JTN <jtn@jd.se> --- * Thomas Nimstad * #pragma message("Standard disclaimer in use") * Juristdata AB, SWEDEN * Professional development for Win32 * Phone +46-500 412150 * Fax +46-500 412848