The program is simple it marries to systems.
1. a program written in VB using SQL.
2. an accounting system written in VFP.
The idea is to prevent fraud. Checks are prepared and written in the VB program to a SQL table. Then once a week (the one day checks are written) the check information is transferred to the VFP program and processed for transmission to a bank. Total number of records is approximately 80000 from four tables. Then information is processed for the accounting system. I considered breaking up the two processes but it appears it really does not change the number of required number of records transferred.
With 24 locations writting approx. 5,000 checks each month - I think the number of records I'm getting is small. And of course the accounting staff work only 8-5 - So the hit on the system occurs during the middle of the day.
I think the DBA should consider setting up a warehouse.
John
John Fabiani
Woodland, CA