What can increase performance of WebSQL on iOS devices?

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