Re: ODBC

My own experience with ODBC Access 2.0 32-bit drivers is that they are much slower than direct a direct API interface to the table native format like Codebase++ 5.1. But that may not matter depending on your application needs. I needed a multi user application (on NT) with many simultaneous queries. ODBC's performance and memory usage was poor on this environment where the application is open, then do one query, print results, and exit. After a few performance measuremnts (using performance monitor) I decided to switch to something else (which turned out to be Codebase++ 5.1 using dbase file format). I can see where I would use ODBC on a single user application where the ODBC DLLS are loaded once, and multiple operations are done thereafter. I hope this helps, Javier In article <D5wn99.2Ey@tfs.com>, clawton@mailhub.tfs.com (Chris Lawton) wrote: > >Hi. > >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. > >Anyone have any real-world numbers they'd share? Any benchmark tests? >Something like workstation A running App X using ODBC compared to >workstation B running App X using vendor provided connectivity? > >Or even just comments like "ODBC seems slower." >I just want to have some feel for what I might expect before I start >my own tests. > >Thanks in advance.... > >Chris Lawton >clawton@tfs.com