During early R&D on our mobile data collection product written for windows mobile we came up against the issues of the un-reliability of MSSQL for Win CE, so we decided to look at alternative options.
The key areas which we stumbled on with MSSQL for Win CE were:
1. Poor Database Performance
2. Corruption of Data due to power failure on device
3. Poor replication on MSSQL for Win CE with backend databases
4. Bloating of Mobile Database
We found a super alternative which is SQL Lite!
Much faster, much much faster in fact its lightening fast
Extremly fault tolerant
In terms of replication .. well we wrote our own replication engine .. more on that later
Very small foot print
We hand coded our replication using SOAP filled with data objects, and we built a http compression engine to optimize comms with the backend.
Following on from this we built synchronisation engine, where we could do a number of things.
1. Backup entire database to MSSQL backend
2. Incremental backup of database to MSSQL backend
3. Built some a data synch engine with simple workflow allowing jobs to be pushed out to mobile users from a PC client, fulfillment of jobs on the mobile client and final synchronisation back to complete workflow.
Publish Post
Looking surveying instruments in locality? Janak India offer surveying and positioning equipments, surveying software,survey equipment, survey instrument,survey services in Delhi, Noida. Book order for surveying equipments at Janak India.
ReplyDelete