Advertisements

Apple Delaying LTE for iPhone Until 2012?


I realize that Apple was able to successfully delay a 3G iPhone for a year because of the lack of competition but the rumored delay of a 4G (LTE) iPhone for a year has me scratching my head. I know Apple likes to tout their user experience and there will be some initial concerns with LTE antenna performance and they were able to get away with it before thanks to a crappy smartphone market but I think they’re really making a mistake with this one.

How much would this impact market share? Let’s assume that an LTE version of the iPhone comes out during it’s usual release cycle in July 2012. That is 21 months from now. With Verizon making commitments to rolling out significant portions of their LTE infrastructure by the end of this year and AT&T by middle of next year how far behind will Apple be exactly? I’ve already decided that I’m likely to purchase a LTE smartphone next year be it iPhone, Android or Windows Phone 7 (which is now even more likely thanks to UVerse integration). If Android and WP7 beat the iPhone to the 4G market by over a year you’re going to see some major hits to their market share.

Advertisements

SQLite for WP7 – Proof of Concept – Improved? (Updated)


Inspired by Dan Ardelean’s SQLite for WP7 Series – Proof of Concept post and the fact that a potential client wants to do a Windows Phone 7 project with SQLite I decided to take a look and see if I can’t find anyway for the solution to be feasible. So I took his initial project, edited the insert so it would insert 19 rows and then added a button to select them back. I also put a rough timer on each of those operations to see what would happen.

The results were not good. Inserting 19 rows took 92(!) seconds and selecting them back took 7.5 seconds.

Looking around on the interwebs I found a lot of comments on poor Isolated Storage performance and chalked it up to that. I finally had some time to look into the issue today what I found gave me hope.

I realized that Dan wasn’t trying to come up with the solution to the SQLite question but merely to prove that it could be done. After digging through the code for the SQLite library (with which I had zero experience) I found this in a method that was being called 23(!)(again) times during my one select statement:

using (var theStore = IsolatedStorageFile.GetUserStoreForApplication()) {    if (flags == SQLITE_ACCESS_EXISTS) {        pResOut = theStore.FileExists(zFilename) ? 1 : 0;        return SQLITE_OK;    }    .    .    .}

When stepping through the code I noticed that getting the IsolatedStorageFile object out of Isolated Storage was an expensive operation (as would it turns out verifying the file exists). So out of curiosity I put the IsolatedStorageFile object into a class level static variable:

private static IsolatedStorageFile theStore = null;

set the value once and tested it out. The results were encouraging. My select statement now only took 1.4 seconds.

It wasn’t great but at least it was a step in the right direction. I then decided to skip verifying that the file exists (for now) just to see what that does to performance:

pResOut = 0;//pResOut = theStore.FileExists(zFilename) ? 1 : 0;

Now I was getting somewhere. 153 milliseconds.

So what does any of this mean? To me this means that running SQLite in IsolatedStorage just might work. Of course the insert still takes forever and a day to execute but the fact I can make a select query go from 7.5s to 153ms just by hacking through the library for a couple hours makes me think that somebody out there somewhere just might be able to make this a feasible solution to Microsoft’s refusal to include relational database support in this version of WP7.
I’ll post the updated code here later (assuming anyone even finds this post).
Update (7/19/2010):

I ran the code again against the updated beta version of the tools and my select now just takes 7ms so obviously performance improvements have been made to the latest version of the platform.