Mac OS X, iPhone & Android Development
Archive for December, 2009
Speeding up SQL on the iPhone
Dec 29th
So, while using %LIKE% is a good option for a small dataset, the iPhone doesn’t have the CPU power to trawl through a large dataset quickly. Using PHP with sqlite, we took the large data set which has a description field in it, and split it down to a type of index table. With this, we were able to use the = and get better accuracy.
Example:
Field has index of 34 and a data field of “this is the best movie we have seen”
Our PHP script split this into another table which the main search looks at:
34 this
34 is
34 the
34 best
…
34 seen
As you can see, we could look for ‘best’, get the index of 34 and pull out the result very quickly. We hope this is useful to someone out there!
Numeraders 2.0 update
Dec 12th
Its been a couple of weeks since we talked about a Numeraders update – it is all going well. We are pushing to have it out before the holiday break – but if not, it will be early January. We have a few live iPhone projects on the boil – which is good. We *may* post up a prelim screenshot for you to look at…maybe, maybe not….