执行INSERT查询时,sqlite将在一定时间内将整个数据库锁定一段时间。有没有办法计算持续时间?如果这是不可能的,你认为sqlite(v3.3.7)是否仍然适应上述条件?@H_502_2@
我会推荐一些其他解决方案,例如MysqL或Postgresql,都可以很好地编写脚本。所以,如果我是你,我会把我的努力放在安装脚本中。@H_502_2@
为了避免sqlite信徒和仇恨者之间的火焰战争,让我吸引您注意经常提及的SQLite When-To-Use文档(我认为它被认为是可信的来源)。这里他们说:@H_502_2@
Situations Where A Client/Server RDBMS May Work Better@H_502_2@
High Concurrency@H_502_2@
sqlite supports an unlimited number of simultaneous readers,but it will only allow one writer at any instant in time. For many situations,this is not a problem. Writer queue up. Each application does its database work quickly and moves on,and no lock lasts for more than a few dozen milliseconds. But there are some applications that require more concurrency,and those applications may need to seek a different solution.@H_502_2@