Please help
I have a file with more then 1.5 million transaction (T). This need to be compare with another master (M) file and if I find a match replace the transaction (T) file field with something. ID number (numeric) is matching field in both the files. I used VFP6.0 Seek command to find the matching. This works fine, but this will take long time like 8 to 10 hours to process the file. What is the best way to do this? How can I reduce the time?
Thanks
Tim
I have a file with more then 1.5 million transaction (T). This need to be compare with another master (M) file and if I find a match replace the transaction (T) file field with something. ID number (numeric) is matching field in both the files. I used VFP6.0 Seek command to find the matching. This works fine, but this will take long time like 8 to 10 hours to process the file. What is the best way to do this? How can I reduce the time?
Thanks
Tim