Help! I’m syncing!

Go read this excellent post by Kevin Closson on log file syncing.  Go ahead, take your time and absorb it.  A reminder that the Oracle wait events can contain a significant amount of “waiting to run” time without being called as such.  I don’t have a pointer to it, but Cary Millsap from Hotsos has done a lot of advanced work in describing wait time components including thinking about time on the runnable queues…

I wonder if there’s a decent methodology for determining a CPU scheduling / priority / affinity algorithm for Oracle background processes?  Sounds like a good whitepaper to me!

The rest of this post has to do with my preference to avoid data syncing (not log file syncing…).  I’m a gadget guy, so I’ve got 2-3 PCs and 2-3 mobile devices in my household.  Over the past 2-3 years I’ve gotten far away from trying to keep all of the machines “in sync” with software and data.  I’ve become a big fan of web-based / server-based applications and data because I just don’t have the time to deal with differences in my small environment.

It’s with this attitude that I’m extremely disappointed with Microsoft for eliminating Outlook Mobile Access in Exchange Server 2007 in favor of Exchange ActiveSync.  I understand that the OMA function in Exchange 2003 was problematic (although I never had a problem with it), but it was dirt simple.  Point your WAP mobile browser at http://your_exchange_server_here/oma and volia, lightweight access to your email, calendar, etc.  No syncing needed, no out-of-sync data.  As long as you had a cell signal, you could get your mail.  No security worries about data on the device, because it wasn’t there.

Contrast this with Exchange ActiveSync — I’ve read the documentation and I’m still not clear on how it works — other than I need to use a Windows Mobile 6.0 in order to take “full advantage” of it.  ActiveSync on the iPhone?  No.  On your generic phone running Opera Mini?  No.  More time spent by IT supporting and helping people configure Exchange ActiveSync?  Yes.  Who does this benefit again?  Why all this emphasis on “off-line” access (with its associated security concerns) when “on-line” access is getting more and more ubiquitous?

BTW, this is why I’m also not a big fan of data copying / syncing within databases either — more places for stuff to go wrong, more complexity.  By all means, use it if you need to, but spend time making sure you really need it.  I think you’d rather spend time adding value to the data instead of writing more code and procedures to make sure the data simply moves from one place to another…

Leave a Reply

Posting code can be a pain. To make sure your code doesn't get eaten, you may want to pre-format it first by using HTML Encoder