We do the increment of 1000, when the record reaches number which dividable by 1000, we delete the record.
-----Original Message----- From: sqlite-users <sqlite-users-boun...@mailinglists.sqlite.org> On Behalf Of Robert Hairgrove Sent: Monday, July 15, 2019 4:00 PM To: sqlite-users@mailinglists.sqlite.org Subject: [EXTERNAL] Re: [sqlite] how to delete BLOB object from the data base 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 generated by SQLite are only accurate to the nearest second. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org https://urldefense.proofpoint.com/v2/url?u=http-3A__mailinglists.sqlite.org_cgi-2Dbin_mailman_listinfo_sqlite-2Dusers&d=DwIGaQ&c=jOURTkCZzT8tVB5xPEYIm3YJGoxoTaQsQPzPKJGaWbo&r=4Y1ZhFy9bpH-wvkl_u5WMmphQqcZcyyY0DFEINZ4E6I&m=JgVnpDzYgWWXrCfLyoOP5F3fhNn1Gk3rk2t6Ak5G8Tw&s=9h4tFOoFd335e5M_jT34B0HuiTqMKR2HMqh_E0wcp1Y&e= _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
