Updating a sqlite database from text file
I am new in database, sorry if this is inconvenient to ask. I am
developing an android application the database of which has a table with
thousands of entries. This table is generated from a backend oracle
database and has to be updated with the changes in the backend database
every time an update button is clicked on the android app.
The procedure that I come with is here: 1) A text file is generated from
oracle database by running an sql script every three hours. 2) Each time
it is needed, the android application downloads this text file, dumps the
old table and parses it into the new table.
My problem is that since the text file is very big with thousands of lines
(around 5mb), downloading and parsing takes very long time, which needs to
be (almost) instantaneous.
My questions are: (1) Is there a better way to update the sqlite database
from oracle backend efficiently; (2) Since parsing takes too long, is
there a way to setup the sqlite to work with the text file, skipping
parsing.
Thanks, any help is appreciated.
No comments:
Post a Comment