mercredi 4 novembre 2015

Slow SELECT in sqlite on Xamarin.iOS

My developers are currently writing an app for iOS using Xamarin. We are using sqlite to store our data.

Now we have a screen that displays a complete sqlite table in a UITableView. There are 16000 rows in that table, and the SELECT * FROM table takes 3 seconds to complete.

Is there a way to speed up this query? An index wouldn't help so much as we need to get all columns anyway.

Aucun commentaire:

Enregistrer un commentaire