Hi,

I am trying to create a query to find unmatched records between two tables. These two tables will grow with time, maybe more than 100,000 records in each table. Is there anybody has rhe experience how long it will take to compare and get query result if each table contains very large data?

Thanks very much for your kind help!
Littleneo

A relative question.

For 100K in each table with each table being small in columns it probably won't take more than a few seconds.

With a large number of columns or many memo fields, etc could take minutes

If these are truly huge files, one way to shorten the time frames is to create a new database of linked tables. Create a local table of the keyed fields of each and run the query against the keyed fields only.

You can then use the results to pull the actual records for whatever you need


HTH

I have 65 fields in tables, but no memo field. Will it cause the problem?

Thanks for your kind reply!
Littleneo