使用transaction:
var stopwatch = new stopwatch(); using (var cmd = new sqlitecommand(db_con)) using (var transaction = db_con.begintransaction()) { stopwatch.reset(); stopwatch.start(); foreach (var item in sorted) { sql = string.format("insert into db (st1, st2) values ('{0}', {1})", item.key.replace("'", "''"), item.value); cmd.commandtext = sql; cmd.executenonquery(); ++readcnt; if (++readcnt % 1000000 == 0) { console.write("\rdumped {0} lines...", readcnt); } } console.write("\rcommitting...."); transaction.commit(); stopwatch.stop(); console.write("\rdumped {0} lines using {1} seconds...", readcnt, stopwatch.elapsed.totalseconds); }
您可能感兴趣的文章:
如您对本文有疑问或者有任何想说的,请 点击进行留言回复,万千网友为您解惑!
网友评论