PennyH <[EMAIL PROTECTED]> writes: > > > My question is How can improve delete speed? This speed can not satisfy my > application. >
A) One potential speedup is wrapping all the deletions in a transaction; if you don't, the default behaviour is to make every separate 'delete' an action verified committed to storage. Hence you would 1) Issue "BEGIN;" command 2) Perform deletions 3) Issue "COMMIT;" command B) Another approach (which could be used as well as using a transaction) if you just want to avoid the big time penalty in one place, would be to add a LIMIT clause to your deletion. http://www.sqlite.org/syntaxdiagrams.html#delete-stmt-limited You would then do deletes, some other work, more deletes, ... until all your required records were deleted. Regards, MikeW _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
