>>
>>I've profiled the program and 95% of all the time taken is in that write to table/fpt command, is there anything I can do?
>>
>>
>>Ken.
>
>Any chance of using SQL Server or SQL Express as the datasource? Then you could do the work in an SP on the server which would probably be MUCH faster..

I've got mysql server running on the processing machine, but using that to store the data would mean rewriting the sorting and matching part of the program, which is a lot of code and is currently fast, getting the data from memory back onto disk as a foxpro table is the bit that is slow. once I've got that bit done it sorts and matches in seconds and then writes out to a pipe delimited file in seconds.