Android Question Fast search on text column in SQLite

[tummosoft]

I have a table with about 500.000 rows. I need to do searches like: SELECT * FROM names WHERE name LIKE 'abc%'. And display them in customgridview.
But, even with an index, it's too slow on Android. How can I make it faster? Can sqlite be forced to internally perform binary search on the text column?

 

[Erel]

There is no such thing as binary search for a "wildcard" text search.

You need to use the FTS feature: https://www.b4x.com/android/forum/threads/searching-database.16167/#post-92295