According to several heavy sqlite users on HN, performance is improved if you do locking at the application layer. No idea if this is true.