| Solution
The client application was designed in MS Access
and was querying data from MS SQL Server database.
Due to certain inherent flaws in this procedure including
poor query structures, lack of indexes in the database
and high volume of data, their queries were accessing
data from multiple tables and this resulted in very
slow processing of their reports.
MS SQL Server stored procedures and views were used
in place of the Access queries, thereby providing
scope for improving the query structures and quicker
access of data.
By building the right indexes in the MS SQL Server
tables, using views and techniques such as simulation
and benchmarking of the queries improved performance
by up to 500%.
|