mercredi 16 septembre 2015

Inserting long blob into SQLite with memory constraint

In my mobile app using SQLite.NET, I could end up with a long blob filestream data string (20-25MB) to store in a SQLite database.

When building the insert or update statement, I would like to avoid putting the entire contents in a single statement.

I was considering chunking the data:

 Insert initial chunk of long data string
 while more data
      Update table by appending the next chunk to BLOB column using || concatentation

Is there a more efficient approach to getting this data into the SQLite database?

Aucun commentaire:

Enregistrer un commentaire