Reputation: 5802
Could SQLite be an alternative for mysql in high traffic web sites? Thanks
Upvotes: 3
Views: 1209
Reputation: 41
SQLite usually will work great as the database engine for low to medium traffic websites (which is to say, 99.9% of all websites). The amount of web traffic that SQLite can handle depends, of course, on how heavily the website uses its database. Generally speaking, any site that gets fewer than 100K hits/day should work fine with SQLite. The 100K hits/day figure is a conservative estimate, not a hard upper bound. SQLite has been demonstrated to work with 10 times that amount of traffic.
Source: http://www.sqlite.org/whentouse.html
Upvotes: 4
Reputation: 8829
The short answer is: SQLite is embedded database. It is purpose is different than standalone RBDMS. While it is quicker with simple queries than MySQL, keep in mind that SQLite has:
Then if you do not plan to use SQLite over network, database sizes are quite small, queries are rather simple, and you have a lots of reads (and really small number of writes), then SQLite may be a better choice.
About MySQL: optimizing and using MySQL in super high traffic sites is not for faint hearted. I recommend some good reading:
Upvotes: 2
Reputation: 1477
Only if you push your data to a cache and read from the cache. SQLite can be used as persistence for cache, but its really not recommended.
Upvotes: 1
Reputation: 3895
No way. SQLLite deals terribly with concurrency. The database would be a huge performance bottleneck.
Upvotes: 2