|
This application was created by using stored procedures and
triggers to execute a single query. This query pulls data from more than 30
different database tables, and generates flat file reports taking advantage of
Microsoft's ADO API
, and was built using common components through COM .
- A local SQL Server was built to serve as a proxy between the Phoenix database and the application. The data sets were massive and the bandwidth was tight, sometimes causing the queries to run for over 3 hours.
- This time lag necessitated a replica of the Phoenix server to be created and located locally, allowing the applications queries to be run against it. This change brought the execution time of the queries to less than 30 minutes.
Previously, without this application, the client was unable to report on claims they had paid, losing money on each claim.
They are now able to accurately report all of their claims and receive their due reimbursement checks from the state of Illinois.
«Back |
