fpODBC speed any faster on 5.6 platforms?
Robert Haussmann
haussma at nextdimension.net
Sat Apr 8 16:41:44 PDT 2006
> > > 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?
>
I certainly should have specified--in my answer I was referring to
high-level access (based on Walter's question). Of course with
low-level access, you are utilizing the ODBC driver directly,
and any queries completed would have the same performance as
they would in Excel or any other ODBC-consumer.
Bob
More information about the Filepro-list
mailing list