Re: ODBC

In article <D5wn99.2Ey@tfs.com>, <clawton@mailhub.tfs.com> writes: > > 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 > We have a BAD expierence with ODBC. We have developed a Form Recognition software (named TopForm) which recognizes forms with field zones on it and save the information in databases. We have impemented the ODBC to support a wider range of databases in our product. 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. Now we changed this support and we save the information in our private DBF file, but allowing the user to export via ODBC. Meir