I have a SQLite database that’s approximately 50mb (~23000 items) in size which I am using to store mesh data to be loaded into my Unity project. An UPDATE on that data when debugging through Unity on my mac takes approx. 1.5 sec. Running the same code on the device takes approx. 10 sec. Does anyone know of any particular reason why the same code would act so drastically different on the two platforms? Is it a mono thing? A device thing?
I ended up figuring this out. I had forgotten to index my databases. I was also using Guids as my primary keys in several tables. After switching my primary keys to ints and indexing the databases, performance is about what I’d expect. The database can do lookups on 100k elements in under a second. That’s fine for my purposes. This wasn’t a unity or iOS problem, just a stupid programmer problem 