Hamad Sultan wrote:But the Data insert when Internet connection available. When we loss the internet connection then what can i do? I am confuse here then what strategy i adopt?
The second one as the time passes the database becomes heavier i.e after 1 to 2 years. and data send to remote server and fetch from that takes time. what procedure i adopt?
Hamad Sultan wrote:The second one as the time passes the database becomes heavier i.e after 1 to 2 years.
Knute Snortum wrote:I would try to do it all in SQL, but I don't know how in MySQL. Maybe try googling mysql merge table from remote to local.
Hamad Sultan wrote:1. Localhost database just save the data and generate monthly reports within an office. It seems good and i will do it .
2. Why i need cloud database ? Our Manger office sit another city and he wants to see some parameters on its desktop like what turbine is running and how much flow is pass from the selected Compressor Station.
I have 15 compressor stations and Each compressor station have separate application and save the record at localhost individually.
Now our manager wants to see the data which station he choose to see some parameters.
Hamad Sultan wrote:So guide me what is the best option between following:
1. first save the data to the excel sheet and when internet connection available send it to domain database after successfully the records on the excel sheet will be deleted and save new records ?
2. Second one is save to localhost and then send to domain and delete that records after insertion.
Every time you till, you lose 30% of your organic matter. But this tiny ad is durable:
Devious Experiments for a Truly Passive Greenhouse!https://www.kickstarter.com/projects/paulwheaton/greenhouse-1