Sqlite Experts, I have a table contains the BLOB object, 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. After almost of 100,000 insert, delete and select operations, I am getting the SQLite_locked error on delete, and my data from the select statement are junk. To prevent the database fermentation, I tried PRAGMA incremental_vacuum(1000) and PRAGMA incremental_vacuum; The performance improved some when I starting using PRAGMA incremental_vacuum but I am still getting the junk data. Am I using the incremental_vacuum correctly? And is there any optimal way to delete the BLOB object in the database table
Thank you, Liang Zhu | Lead Software Engineer | Branson Ultrasonics Emerson Automation Solutions | 41 Eagle Road | Danbury, CT 06810 | USA T (203) 796-2235 | F (203) 796-0380 liang....@emerson.com<mailto:liang....@emerson.com> The information contained in this message is confidential or protected by law. If you are not the intended recipient, please contact the sender and delete this message. Any unauthorized copying of this message or unauthorized distribution of the information contained herein is prohibited. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
