Suppose you have an old system (Access based) to make bills, invoices and else. You have to process some information monthly, not daily, from a not indexed field. How I boosted the system:
- Create a SQL Server Database with tables with the fields that you need to search. Thousands of clients in my case. The OleDb DataReader is really fast reading.
- Bulk the data readed into the SQL Server.
- Read from SQL Server, if not, update the SQL Server information.
Simply but I did not realize until today. Better than improving code.