Are you accessing the database across a network, or is local on the server? Are you using a transaction, or are these individual inserts? I'm using system.data.sqlite.dll for a file backup program and that happily rattles through 800,000 inserts (continuously) without issues. Its worth noting that v103 was recently released, so the v89 you're using is fairly old. Thats not the cause of the problem, but it may not be helping.
Thanks, Chris _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users