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

Tap the Share icon in Safari
Scroll the menu and tap Add to Home Screen.
Tap Add in the top-right corner.

To install this app on Android

Tap the 3-dot menu (⋮) in the top-right corner of the browser.
Tap Add to Home screen or Install app.
Confirm by tapping Install.

FMForums.com

Sign In

Email Address

Password

Remember me
Not recommended on shared computers

Forgot your password?

Or sign in with...
Sign Up

Lookup import advice

April 12, 20187 yr

Hi gurus,

Need some advice, I am putting together a job tracking system for a print-shop and I am running into a dilemma where I need some advice. Our ERP is Sage 100, but unfortunately I have not been able to retrieve data from it using ODBC, it appears File Maker ODBC is not compatible with SAGE as I keep getting an error (it works fine from excel but not filemaker).

I am currently exporting all the needed data to various CSV files and importing them into a single filmmaker database with a table for each CSV. some of this tables contain as much as 30K records. my issue is with speed. every time there is a lookup it sometime takes a few seconds.

My question is, if I import the data to the main database would the lookup's be any faster.

Thanks for any help

April 14, 20187 yr

I have various tables with a million records (maybe more, haven't looked for a while). Lots of records doesn't imply things get slower. How the schema is organized/structured does.