There are two tables that are linked through a lookup. One table has approximately 15,000 rows. The second table has approximately 80,000 rows. Inserting a new row takes about a minute. Can this be optimized somehow? Thanks in advance for any tips.
There are two tables that are linked through a lookup. One table has approximately 15,000 rows. The second table has approximately 80,000 rows. Inserting a new row takes about a minute. Can this be optimized somehow? Thanks in advance for any tips.