ODBC vs Importing data : performance comparison

[djlane]

I did some testing of having an external application send records to a FM database. I tried 3 methods :

1. Using the Data Direct Sequelink ODBC where the application directly sends records to FM

2. Having the application send the records to MYSQL via the MYSQL ODBC Driver 3.51, and make that MYSQL database an external data source in my FM database.

3. Having the application send the records to a .csv file / files and having FM import the records from the .csv files.

With method 1 it took the application 109 seconds (!) to send just 7 records to FM.

With method 2 it took 54 seconds to send the same 7 records.

With method 3 it took about 1 second to get more than 600 records in more than 100 .csv files into the FM database.

So, unless you need that “live” connection, stay away from ODBC !

[mr_vodka]

yeah the ODBC driver is slow as a turtle.