0

Right now in my app I connect to a MySQL DB as a "as needed" for getting information on a online game I play (the app is a sort of information based and a performance enhancer for game-play), but I now find myself seeing that on an orientation change or just hitting back and going back into the same section of the app I always have this loading that needs to happen which even to me gets me a bit upset/frustrated on the wait time that needs to be done which will disturb the user experience which I 100% want to avoid.

So my questions on this was:

  1. How can I get the entire MySQL DB onto the phone quickly and efficiently?

  2. When the app exits does the DB table still reside there on the phone?

JoeyL
  • 1,295
  • 7
  • 28
  • 50
  • how big is the db? is it reachable via webservice or it's local? – gpasci Mar 24 '13 at 05:43
  • @gpasci webservice, and the DB is not big, it is around 7 tables. – JoeyL Mar 24 '13 at 05:43
  • it really depends on data size and on how often you need to retrieve _fresh_ data. try to be more specific. options are, fetch all db one time only on app install/first run or fetch data at runtime when needed and cache accordingly to avoid heavy network usage – gpasci Mar 24 '13 at 05:46
  • http://stackoverflow.com/questions/6511402/how-to-sync-sqlite-database-on-android-phone-with-mysql-database-on-server or maybe you want to convert your mysql db to sqlite and just put in your apk :) – gpasci Mar 24 '13 at 05:48
  • mysql DBMS isn't available on android, atleast until now. If you want to save Data on android, you can use sqlite. And that also is not recommended to store large amount of data. –  Mar 24 '13 at 05:54
  • @gpasci Yes I was thinking about converting the mysql db to sqlite (just wasn't sure how lol). But since the game I play adds characters, item stats get changed, and the spells of the characters tend to get tweaked is it possible to: "User loads app > check if mysql db version matches sqlite version > if not a match take the mysql db and convert to a sqlite db for use? – JoeyL Mar 24 '13 at 05:59

3 Answers3

1

How can I get the entire MySQL DB onto the phone quickly and efficiently?

You probably can't. That database could be anywhere from 1.1x - 300x the size of your available device's capacity. The occasional calls to retrieve only what it needs are more efficient than trying to pump (potential) gigabits to its clients.

When the app exits does the DB table still reside there on the phone?

This is strongly dependent on the implementation of the application. If there's a justification to cache that kind of data (I'd presume info such as countries or dates or constant values would stick around), then it might. Otherwise, you'd be better off taking it up with the developer themselves.

I'm not entirely familiar with Android (yet), but at some point in the lifecycle of an application, typically on an orientation change, the application itself is destroyed/recreated for that orientation. It could be that the work to connect to the DB is done in an inappropriate layer, hence why you're seeing such poor performance.

You'd really want to take this up with the developer. If you don't have the source code to change this, there's not much we can suggest that will help.

Makoto
  • 104,088
  • 27
  • 192
  • 230
0

I want to help you, but I need more information about your problem.

What version of MySQL you are using?

You can use SQLite or save and load the data from a xml file.

Regards,

Juampa
  • 2,035
  • 2
  • 25
  • 35
0

You have not to get everything from the database. You just need load the information needed for application.

How to get from a MySql server to an Android app?

Community
  • 1
  • 1
Juampa
  • 2,035
  • 2
  • 25
  • 35