开发者

What can increase performance of WebSQL on iOS devices?

开发者 https://www.devze.com 2023-03-24 11:34 出处:网络
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:

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

0

精彩评论

暂无评论...
验证码 换一张
取 消