Il 10/08/2010 08:30 AM, Michele Pradella ha scritto: > I don't know if could be faster to do more Delete of less records, or > perhaps making a VIEW and than deleting all the records matching the > VIEW. I'm thinking about this to find the fastest solution, because the > problem is that when sqlite is deleting the records obviously I can not > access the DB for insert new records and all the operations have to wait > for delete complete...and 4-5minutes is too much time to wait. Maybe splitting this operation in many Delete of less record lengthens the total time, but results in shortest service interruptions, and may in fact be more acceptable.
Aldes Rossi _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
