Every little bit counts in regards to speeding up the processing of your files. There are many factors involved that can slow processing your SQL files. Here are some pointers from our help file....

Network and file formats.
Slow network topology and/or protocol equals poor results. In general, databases process faster on a local hard drive compared to a network hard drive - there's less hardware between the application (MatchUp) and the data. If you're processing a large file on a regular basis, relocating the database on a local drive may save you lots of time.

File format and file structure play a role in processing speed as well. dBASE, Flat File, and SDF files are processed rather quickly. SQL Server, DB/2, and Oracle process slower than dBASE, but the speed hit is largely dependant on the network topology and load. Delimited and ragged SDF files are processed much slower. ODBC files are typically processed rather slowly as well, but it is largely dependent on the ODBC driver used. Performing file updates also adversely effect MatchUp's processing speed. Scattering, Status codes, Count Fields, etc. all slow the process.

Table Structure:
Although field name and field position are critical to proper operation, field sizes can be extended if necessary to accommodate larger lookup strings. However, this should be done economically, as excessively large lookup fields will slow performance.

Let me know if this helps.