jeudi 13 août 2015

For better performance, saving a path to a file or the file itself into the SQLite table?

i am populating sqlite table via java JDBC, and the table is expeted to contain more than 500 million lines and it is structures as follows:

PK  NodeID  LAT    LNG    xmlFile
1   2342    33.4   21.34  c://city_0.xml
..  ...     ....   ....    ...........

and the purpose of that table is, to retrieve the xmlFile according to a given the lat and lng. and the xmleFile "c://city_0.xml" is saved on the hard drive.

and later i want to use that sqlite table in an App in Android.

my question is, since i would use that table in android App. for better performance and speed,

1- should i copy all these files .xml on Android device's SD card? or instead,

2-i should save the xml file itself file.xml in the sqlite table.

Note: if case the first option is the better, there will be 600 .xml files with total size of 670 MB to be copied into Android#s SD card!!

please advice?

Aucun commentaire:

Enregistrer un commentaire