Boost your Small Business Monthly Processes

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:

  1. 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.
  2. Bulk the data readed into the SQL Server.
  3. Read from SQL Server, if not, update the SQL Server information.

Simply but I did not realize until today. Better than improving code.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s