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