Android Question SQL slow, how to optimize?

[wimpie3]

I'm using an SQL DB in my B4A app and I have the impression the MySQL engine from Android is not really fast.

Are there faster alternatives? Or ideas on how to optimize queries? I already added indexes of course.

I'm used to the server speed of a Windows MySQL server. Perhaps my expectations are simply too high

 

[OliverA]

Are we talking about the build in DB for Android? It's based on SQLite. What type of DB queries are you running on Android that you deem slow?

 

[eps]

Without knowing the SQL or the data structure it's quite hard to help.

1) What are you retrieving

2) Is the database on the device? If so it's a SQLlite DB.

3) Have you looked at optimising the SQL retrieval?

4) Have you looked at optimising the DB architecture?

5) Check indexes or at least analyse the SQL and structure - sometimes these come up with hints of how to optimise the retrieval.