On Fri, Dec 27, 2013 at 4:14 PM, Igor Korot <ikoro...@gmail.com> wrote:
> Hi ALL, > Does people use SQLite for Web development? Or web apps are written > only with mySQL/MS SQL? > The www.sqlite.org site uses SQLite, of course. That site gets between 200K and 300K HTTP requests per day, depending on the day of the week. About 3/4ths of the requests are for static content but the other 1/4th (23.73% over the previous two weeks) are dynamic content which must consult an SQLite database, usually via Fossil (http://www.fossil.org/). The server is leased from Linode (http:/www.linode.com/) and is a 1/16th slice of a real machine. The load average is typically about 0.05. You can visit one of the dynamically generated web pages like http://www.sqlite.org/src/timeline to see that response-time is very fast. The aforementioned timeline page requires about 102 differ separate queries to render. Add this all up and SQLite is doing about 75 queries/second every second, all day long, on 1/16th of a server with a load average of less than 10%. That kind of performance covers a lot of websites. One rule of thumb is that if you and run your website from a single server, SQLite is sufficient. If you need multiple servers, then consider a client/server database engine like MySQL or PostgreSQL. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users