Android Question SQL slow, how to optimize?

wimpie3

Well-Known Member
Licensed User
Longtime User
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
 
Sort by date Sort by votes

OliverA

Expert
Licensed User
Longtime User
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?
 
Upvote 0

eps

Expert
Licensed User
Longtime User
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.
 
Upvote 0
You must log in or register to reply here.

Similar Threads

  • Question
Android Question SQL has several possiblilities: which one?
Replies
4
Views
704
Shelby
  • Question
Android Question SQLCipher 1.6 and 1.3
Replies
7
Views
1K
jatko
A
  • Question
Android Question SQL Speed-Question
Replies
1
Views
573
sorex
S
D
  • Question
Android Question What is the fastest method (SQL question)
Replies
3
Views
1K
DPaul
D
  • Question
Android Question Fast search on text column in SQLite
Replies
1
Views
1K
Erel
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…