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