Android Question Good Database Practice

[metzeller_2013]

Good day Sir Erel,
I'm currently developing an App which has 9 Tables saved in csv format, I was wondering if what approach should i use in importing them to the app. Each table would probably hold at most a thousand records with 20 columns at max. Should I save them in a single database or in multiple database file?
I was thinking if this would affect the system performance of the App....
Hope you can help me.... Thanks in Advance.... Noobie here....

 

[edgar_ortiz]

Use a single Sqlite database and create 9 tables, the performace is excelente.

Regards,

Edgar

 

[metzeller_2013]

Thanks edgar for the replay..

 

[JakeBullet70]

+! for Edgar, he is right and also do not forget your indexes

 

[metzeller_2013]

how about considering a scenario of data corruption? Is it not that a single file is prone to data corruption?
And please any advice on what storage to save the database? Internal or External Storage???
Thanks..

 

[edgar_ortiz]

In my knowledge... when you are using SQLITE... if a data corruption occurs, you can't open the database.

I have few application that use SQLITE and NO problems.... Just be careful of close the database when you application finish.

Regards,

Edgar

 

[JakeBullet70]

I have never had a SQLite corruption issue and I have used SQLite for over 6 years.
Also backup your database.

Internal or External Storage? does not matter.