I dunno, seems like a lot of work for a relatively a simple app. They're just trying to automate a process that is currently done manually.

FYI - The invoice table has 600K rows.

The COM component might be the best route.





>There are other options.
>
>Write a COM component in VFP, and instantiate it. But I'm not convinced it will be any faster.
>
>Another option is to automate the process. When a PDF file is dropped into a folder, the .Net application picks it up and reads the data then writes it to MSMQ. A VFP application then reads the information from the queue and writes it to the dbf. Both the .Net and VFP applications would run as services so they're always running.
>
>
>>That's what I'm doing now.
>>
>>The app reads PDF's full of invoice payment information into into VFP tables. It looks up the invoice in one table, then writes the payment data to other VFP tables.
>>
>>The client reported that the application took 6 hours to complete, so I need to find a way to speed it up.