Need fast database for Android-based mobile device apps

I use SQL Server CE for my legacy apps that run on Windows CE-based mobile computers such as scanners, and I make heavy use of indexes for my tables, to keep the performance high.

Now I am having to get outside help to rewrite my apps for newer mobile devices running the Android OS.  Database performance is poor in some cases.  Today the developer revealed that he uses SQL Lite, and he says it has no support for indexing--meaning that the new app is often (slowly) reading through every record in the local database.   He says there is nothing he can use that supports indexes--like my good 'ol legacy apps do.

I'm not convinced.  I need to know if there are alternatives to SQL Lite that support indexing--just like my SQL Server CE does.  Even if it is not free, I want to consider it, so I can get my database tables running just as fast in my new Android-based app as they did for my legacy app that was designed ten years ago.  TIA
LVL 3
sasllcAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Chris Harte2015 Top Expert (Most Article Points)Commented:
no support for indexing
Sounds like you need a new developer. Here is a tutorial on how to use indices in SQLite.
http://www.sqlitetutorial.net/sqlite-index/

The SQLite documentation page also has lots to say about them.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
John TsioumprisSoftware & Systems EngineerCommented:
i haven't dealt with Sqlite but i am pretty sure there is  missing part of in the story regarding the developer and sqlite indexes...
0
Lalit KumarAndroid DeveloperCommented:
Hey  @john alternative of Sq-lite is realm . I think you need to use realm database for you Android native app . Please check this link here you find efficiently use of realm database .
https://www.thedroidsonroids.com/blog/android/realm-database-example/


Realm database is 10 times faster than sql-lite database.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.