>I have a mortgage application that needs to load 200,000 transactions from an ASCII file at the end of every month. This process is taking 3-4 hours on the clients PC (350MHz, 64MB RAM). The client wants to be able to load up to 1 million. I am looking for the most efficient way of loading, processing and saving these transactions.
>
>Some ideas:
>1. Split the load file between multiple computers
>2. Sort the load file and the table by loan number and use scan/skip
>3. Try to make code more efficient (difficult)
>4. Get the client to use a faster PC.
>5. What else can I do?
Does the application load the transactions into a VFP table/tables or is the final destination another database, like SQL Server?
Chris McCandless
Red Sky Software