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