fpODBC speed any faster on 5.6 platforms?
Robert Haussmann
haussma at nextdimension.net
Fri Apr 7 14:12:25 PDT 2006
> Has anyone doing fpODBC seen any speedup with the version
> compatible with 5.6?
> I ask this because I ran a report this morning on a MySQL
> database with almost
> 900K records and it was only selecting at the rate of 100
> records per second.
> 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 laughs I did the same query
> in Excel and it
> took all of 4 seconds. This is useing the same OBDC driver
> from MySQL in all
> three instances.
>
> I wonder if there is some optimizations/cachings that MySQL
> has in their OBDC
> driver that optimizes MS products that perhaps
> could/should/would be beneficial
> to filePro.
>
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).
Bob Haussmann
Tabor Children's Services, Inc.
More information about the Filepro-list
mailing list