Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

ODBC vs Importing data : performance comparison

djlane
in External Data Sources

Featured Replies

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 !

Create an account or sign in to comment

https://fmforums.com/topic/67819-odbc-vs-importing-data-performance-comparison/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.