On Dec 17, 2017, at 3:53 PM, Dinu Marina Is there any way to fix/improve this in userland?
I think the thread already has a viable solution but still if userland fix is an option: would a soft-delete based design work for you? https://dba.stackexchange.com/questions/125431/hard-delete-vs-soft-delete-performance -SK _______________________________ *StepSqlite* enhanced-PL/SQL on SQLite and BerkeleyDB. **Coming Soon** ---- Be Done at the Speed of Lite! ---> https://metatranz.com/stepsqlite/ShowSignUp?guestlogin=ON _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users