1. Download our Official Android App: Forums for Android!

Apps SQLite or String Array

Discussion in 'Android Development' started by __Jon__, Sep 9, 2010.

  1. __Jon__

    __Jon__ Newbie
    Thread Starter
    Rank:
    None
    Points:
    15
    Posts:
    15
    Joined:
    Aug 16, 2010

    Aug 16, 2010
    15
    0
    15
    I am developing a very simple quiz app. It's just a standard multiple choice quiz. I am not sure how many questions there will be, but it could go into the hundreds.
    So far I only put in about a dozen questions. All of them are in a string array. However, I'm worried that if I decide to vastly increase the question bank I am wasting time with string arrays and I should make a SQLite DB table instead. That's not too difficult in itself (I hope), but I want to know if a persistent SQLite DB that comes with the app will have negative effects on

    1) Size of App. OK so I guess it will, but is, say, a DB of 2000+ questions going to make the file extremely chunky?

    2)Speed. Is it quicker to search a random row on a DB table or a random element of a stirng array? Of course it depends on size, but does anyone know if it is a noticeable difference?

    3) Battery life. Will a SQLite DB be a bigger drain on battery?
     

    Advertisement

Share This Page

Loading...