My window to the world

Data synchronisation on Windows Mobile

By Mauricio Freitas, in , posted: 13-Dec-2007 09:32

Last year I participated in a project where the IT department for this large company (sorry if I can't disclose the company's name) wanted to select a mobile platform.

The upper management wanted BlackBerry devices because they wanted whatever the guy sitting next to them in the airplane had.

The people working in the front wanted a device that could actually be used for something else than just e-mail.

My suggestion was Windows Mobile - mainly because it was the platform that could easily access their private network through a HTTPS VPN proxy they already had in place, and because it would be much easier to deploy e-mail synchronisation with their Exchange Servers through SSL, without having to invest in additional hardware for a BES server.

One year later I still consider this solution the best option. Take in consideration that now Microsoft is coming out with tools that allow Windows Mobile devices to join a domain and IT administrators have the ability to manage those mobile devices as they would manage any other computer on their network.

The recently announced Microsoft System Center Mobile Device Manager 2008 is looking like a great tool for IT administrators to keep an eye on mobile devices inside the organisation.

Now I read this interesting post about database synchronisation betwen mobile devices and server. The platform runs on SQL Server and SQL Server Compact 3.1 using Merger Replication technologies:


I decided to double the number of concurrent Subscribers to 600.  Keep in mind that each Subscriber is equivalant to a Windows Mobile device.  I used 6 servers running 100 Subscribers each to create client load, 3 load-balanced IIS servers, and a separate SQL Server Distributor and Publisher.  With 600 concurrent Subscribers contending for resources, I managed to perform 22,401 syncs per hour which is slightly fewer syncs than I saw when running only 300 Subscribers back in Vegas.  The important story here is that I almost doubled the number of rows I changed and replicated per hour:
  • Rows changed:  13,440,600 per hour  |  322,574,400 per day
  • Data replicated:  1.45 GB per hour  |  34.8 GB per day


Database is a very cool technology and having the ability to "mobilise" data is one of the most important parts of mobility in my view.

Other related posts:
Windows Phone and Android apps screen comparison
Windows Phone 8 Portico update: at last here in New Zealand
Windows Phone updates, again






comments powered by Disqus

freitasm's profile

Mauricio Freitas
Wellington
New Zealand


I live in New Zealand and my interests include mobile devices, good books, movies and food of course! 

I'm the Geekzone admin. On Geekzone we publish news, reviews and articles on technology topics. The site also has some busy forums. Also worth visiting is TravelTalk NZ, a community for travelers!

Subscribe now to my blog RSS feed or the Geekzone RSS feed.

If you want to contact me, please use this page or email me freitasm@geekzone.co.nz. Note this email is not for technical support. I don't give technical support. You can use our Geekzone Forums for community discussions on technical issues.

Here's is my full disclosure post.

A couple of blog posts you should read:


Social networks presence

View Mauricio Freitas's profile on LinkedIn


My Blog by tags...

Blog...
Entrepreneurship...
Media...
Personal...
State of Browsers...
Technology...
Viral Marketing...
Web Performance Optimization...
Windows...
Windows Phone...

Other recent posts in my blog

Google crawling Geekzone HTTPS...
Geekzone gone full HTTPS...
Microsoft Ignite New Zealand, ...
If the headlines indicate the ...
Geekzone data analytics with P...
State of browsers Geekzone Mar...
2Cheap Cars discussion...
Now with more fibre...
Unlimited is not unlimited: Vo...
How bad is Vodafone cable at t...

New posts on Geekzone