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