fpODBC speed any faster on 5.6 platforms?
Walter Vaughan
wvaughan at steelerubber.com
Fri Apr 7 13:55:56 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
More information about the Filepro-list
mailing list