Click here to Skip to main content
15,867,921 members
Please Sign up or sign in to vote.
3.00/5 (2 votes)
See more:
I am working on a project in WPF, I have its database located on Amazon Cloud server,
This application can run with or without internet connection(Users can do transactions too)
I have to maintain data in some temporary(or local) database so it can work without internet.
For that, I am using SQLite for it, I have made an SQLite file and after every 30 mins, I am updating both Database.This works fine until now,as I was having less data.

Now I have to use the something for Large Data(around 20-30GB or more) ,Is there any alernative thing for this? Kindly suggest what should be the best way to store data locally?
Posted
Updated 23-Oct-14 22:17pm
v2
Comments
Sergey Alexandrovich Kryukov 24-Oct-14 3:06am    
You call 1Gb "Large"... Aren't you mixing up something? These days, a single flash card starts with some 4-8 Gb... :-)
"The best way" actually depends on the structure of your data...
—SA
Mehdi Gholam 24-Oct-14 3:31am    
If it works keep using it.
Syed Salman Raza Zaidi 24-Oct-14 4:16am    
@SA I said just for example, it can be large 10-15GB or more :)

You could handle this manually like Sinisa Hajnal suggested - I just want to point you to a more "automatic" way - the "Microsoft Sync Framework" - did you consider it?

http://msdn.microsoft.com/de-de/library/bb902854(v=sql.110).aspx[^]
 
Share this answer
 
You could have full blown database on the client and work online while the connection is available and offline when not, while syncing the two.

Important part is to try and send to the server first and then after the response of the server write the data locally. And if the server does not respond you still write the data locally, but flag it for syncing later on.

Each time you access the database you would have to handle both. Every now and then you could check the connection with some quick harmless select just to see the database is accessible - by doing this in the background and marking the database offline you can save the user some timeout waiting when he sends his own queries to unavailable database.



If the working set data is smaller then full database (either per user or current transaction or anything like that) - you can write that data locally and work with that without having to keep current copy of the full database. This version could work with any local storage.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900