On 3 Nov 2011, at 6:05pm, Paxdo Presse wrote: > You think SQLite can handle a website / web app that has 1000 readers per > day, including 200 to 300 who will write regularly?
You should be able to handle 10,000 posts a day without problems. A single INSERT command keeps the database locked only for a very short time. Your bone of contention is when you have lots of readers all logged in at the same time, all loading pages which list forum threads and clicking 'next ... next ... next'. If you have 200 or 300 of those all logged on at the same time (not at different times of the same day), you may have problems. But you should be able to deal with even that if you write your code carefully, so as not to keep the database locked for longer than necessary. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users