![]() If file locking does not work the way it is expected, it might be possible for two or more applications to modify the same part of the same database at the same time, resulting in a database corruption. Many NFS implementations are known to contain bugs (on Unix and Windows) in their file locking logic. This may cause some problems if database files reside on network partitions. SQLite uses native file locking primitives to control transaction concurrency. It is optimal in situations where simplicity of database implementation, maintenance, and administration are more important than the countless complex features that enterprise DBMSs provide. SQLite is not intended to be an enterprise DBMS. But there are some applications, especially write-intensive ones, that require more transactional concurrency (table or row level instead of database level), and you should use a different DBMS for such applications. Each application does its database work quickly and moves on, and hence no database is held up by a transaction for more than a few milliseconds. In many situations, this is not a problem. Similarly, if any one transaction is writing to any part of a database file, all other transactions are prevented from reading or writing any part of the file.īecause of its limited transactional concurrency, SQLite is only good for small-size transactions. This limitation means that if any transaction is reading from any part of a database file, all other transactions are prevented from writing any part of the file. It permits many concurrent read-transactions, but only one exclusive write-transaction on a single database file. ![]() Savepoints allow a transaction to revert back to previously established states.) It is not capable of ensuring a high degree of transaction concurrency. (Nesting means the capability of having subtransactions in a transaction. SQLite supports only flat transactions it does not have nesting and savepoint capabilities. You can obtain the latest information from the SQLite homepage. The following is a list of shortcomings of SQLite:Īs mentioned previously, SQLite does not support some SQL-92 features that are available in many enterprise database systems. SQLite follows this goal, even if it leads to occasional inefficient implementations of some features. SQLite is different from most other modern SQL databases in that its primary design goal is to be simple.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |