Re: [sqlite] how to delete BLOB object from the data base

2019-07-15 Thread Simon Slavin
On 15 Jul 2019, at 8:38pm, Zhu, Liang [AUTOSOL/ASSY/US] wrote: > I am getting the SQLite_locked error on delete, and my data from the select > statement are junk. I think you are saying that you get the result SQLITE_LOCKED. To do this you must be A) Using one database connection for two o

Re: [sqlite] how to delete BLOB object from the data base

2019-07-15 Thread David Raymond
The questions coming to mind at the moment: What is the schema of the table holding the BLOBs? What is the normal size for the blobs? How are you doing the inserts and deletes? What journal mode are you using? I would think normal way to delete a record is the simple delete from blob_table where

Re: [sqlite] how to delete BLOB object from the data base

2019-07-15 Thread Robert Hairgrove
On 15.07.19 21:38, Zhu, Liang [AUTOSOL/ASSY/US] wrote: ... I am inserting to the BLOB data into the table at every 250ms, I delete the oldest row at every 600ms, also I am reading the data from the database at every 10ms... How do you determine the "oldest" row? I believe the timestamps gener