I have PhoneGap app running on Android and iOS, it is using WebSQL. One table has 10 columns and about 350 rows. When I run simple query:
SELECT * FROM table ORDER BY name_column
Now this runs pretty good on Android - it takes about 2-3 seconds to execute. But on iOS devices - e.g. iPhone 3G - it takes about 30 seconds and that is unacceptably slow.
Is there any way how to make this run faster on iOS ? Or what would be other way how to accomplish this开发者_StackOverflow中文版 functionality ?
have you tried putting an index on that column? http://www.sqlite.org/lang_createindex.html
精彩评论