SQLite or String Array

Last Updated:

  1. __Jon__

    __Jon__ Member This Topic's Starter

    Aug 16, 2010
    Likes Received:
    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?


Share This Page