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