What is the maximum connections for sqlite3 database?
Any Why I can't use it for very big websites Suppose 3 million users?
解决方案
http://sqlite.org/whentouse.html explains "Situations Where Another RDBMS May Work Better":
SQLite uses reader/writer locks on the entire database file. That means if any process is reading from any part of the database, all other processes are prevented from writing any other part of the database. Similarly, if any one process is writing to the database, all other processes are prevented from reading any other part of the database. For many situations, this is not a problem. 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.