On Sun, Jan 23, 2005 at 11:11:54AM -0500, Jason Morehouse wrote: > We are currently using mysql. What is the comparison to opening a > database with sqlite vs connecting to the daemon with mysql? Our > current box has seen 300+ connections to the sql server at at once. Can > we expect that having 300 databases open with sqlite wont be a problem?
What is your application doing? If this is a website, that is a very large number of concurrent database connections. I'd think you must either have an EXTREMELY busy website, or you're doing something wrong. Why do you have 300 concurrent database connections? Are you using some form of db connection pooling? And if not, why not? I know of some websites running PostgreSQL (and AOLserver and OpenACS) with 50,000+ plus users which regularly see 100+ concurrent users, and while I don't have any exact numbers, I'd be quite surprised if they have as many as 300 database connections configured. Here's one (not ideal, but interesting) example to give some flavor of that: http://openacs.org/forums/message-view?message_id=203277 I'd think that at most, you should only need as many database connections as your peak number of concurrent users. And in practice you'd probably want fewer than that. -- Andrew Piskorski <[EMAIL PROTECTED]> http://www.piskorski.com/
