Lookup import advice

[rudym88]

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

[OlgerDiekstra]

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.