In my application there is a lot of data around 2000 records and the datavase is a online database(MySQL). In the client machine when the program starts database should be connected and from the next process the application should run without database connection. and database should be updated for a particular period of time.
Is cache a right way to solve this problem? If so how can i do it windows application(vb.net)?guide me in this matter. Thanks in advance.