On 11 Jun 2010, at 8:49am, durumdara wrote:

> In SQLite the insertion, select is good.
> But deletion also slow.

Do you have one instruction which deletes many rows or many instructions which 
delete one row each ?  If the latter, put all the instructions inside BEGIN 
TRANSACTION ... END TRANSACTION.

http://www.sqlite.org/lang_transaction.html

Simon.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to