fpODBC speed any faster on 5.6 platforms?

Kenneth Brody kenbrody at bestweb.net
Sat Apr 8 12:41:03 PDT 2006


Quoting Robert Haussmann (Fri, 7 Apr 2006 17:12:25 -0400):

> > Has anyone doing fpODBC seen any speedup with the version
> > compatible with 5.6?
[...]
> > The "same identical query" or rather the query formed simliar
> > (field_title co "T-TOP" vs. field.title like "%T-TOP%") running
> > in Access via linked tables ran about 10 seconds total. Just for
[...]
> Walter--I've reported the same behavior in the past.  Based
> on limited testing, it appears the same in 5.6.
>
> Based on the performance difference, it is our suspicion
> that fpODBC is reading records individually (e.g., one read
> for each record--slow), vs. Excel which would pass through
> the actual query to the mysql engine.  (We see the same with
> MSSQL and P.SQL).

Have you tried using the low-level ODBC access, where you can actually
pass the exact query, rather than having filePro do the scanning?

--
KenBrody at BestWeb dot net        spamtrap: <g8ymh8uf001 at sneakemail.com>
http://www.hvcomputer.com
http://www.fileProPlus.com


More information about the Filepro-list mailing list