vendredi 25 septembre 2015

SQLite running 'some' queries, under iOS9, views a lot slower than iOS8

Just starting to fully test our App with Xcode Version 7.0 (7A220). It makes heavy use of SQLite, lots of queries, inserts, updates and use of views, etc. It's a product-pricing tool and has lots of row iterations so it can pull offers and their various rules and dependancies. It does do a lot when asked. Under Xcode 6, supporting iOS8, performance was fine. Not a problem, instant. When the same App, actually compiled for iOS8, and already installed on the iPad before iOS9, is run, it runs like a snail on smack.

So it's definitely iOS9. That's the only thing that's different. So, back to Xcode 7, I start to debug. Where in the code, is it sticking or where is the performance being affected. I have isolated the sticking, slowness to a query. It's a view, a very complicated view, however, it ran very quickly on iOS8. It's fairly sizeable and I'll post it if asked, but my main question stands... is there anything I need to be aware of as regards iOS9 and SQLite performance? As it is, I'm baffled as to what the problem is. I tried removing the:

sqlite3.dylib

And replacing it with the library that appears to ship with Xcode 7:

libsqlite3.0.tbd

and then

libsqlite3.tbd

But neither helped.

Still running very slow.

Anyone any ideas?

Aucun commentaire:

Enregistrer un commentaire