Database local cache

You are developing a desktop application for managing a fitness center. The members information is of course to be stored in a database, so you define a "Members" table with fields such as name, birth date, telephone, and the like. But your happiness ends when you are faced with the requirement of recording the member's photo together with the rest of the data. Then the second most trascendental question in human history (right after the meaning of life) comes to your mind: Should I store the photo in the database for the sake of data consistency, or in the local filesystem for the sake of performance?

This article presents a C# class that will allow you to grab the best of two worlds.

Read more...

 

No Comments