Does perform well an ASP website with a SQLite database?
-
2This question is way too vague to be answerable. Database performance is entirely up to how you design and use the database.zombat– zombat2010-01-25 02:56:08 +00:00Commented Jan 25, 2010 at 2:56
-
depends on the website, depends on the database.echo– echo2010-01-25 03:02:32 +00:00Commented Jan 25, 2010 at 3:02
Add a comment
|
1 Answer
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.
See: http://www.sqlite.org/whentouse.html
In particular, check out the sections labelled: Situations Where SQLite Works Well, and Situations Where Another RDBMS May Work Better
