mardi 15 mars 2016

Android SQLite Suggestion

I've to implement a parent/child table in my application. Like this:

    Parent Table :  
      id  project_name
    ----------------    
      1     xyze
      2     abcd

    Child Table :
     id   p_id   part  quantity 
    ----------------------------
      1     1     A_1     2
      2     1     Y_6     1
      3     1     Z_2     2
      4     1     L_9     6
      5     2     E_1     1
      6     2     D_9     2
      7     2     A_1     8
      8     2     Y_1     2

Parent Table id is Foreign for child p_id. My concern is that child table will contain nearly 35000 rows. Will android SQLlite be able to handle 35000 approx rows? Will it take large storage space? Detailed answer will be helpful. Thanks.

Aucun commentaire:

Enregistrer un commentaire