> -----Original Message----- > From: [email protected] [mailto:rt-users- > [email protected]] On Behalf Of Tom Lahti > Sent: Wednesday, 25 November 2009 10:55 > To: Ivan Voras > Cc: rt-users > Subject: Re: [rt-users] Is SQLite no longer supported? > > > Slightly offtopic - is there some "best practice" limit saying when > > SQLite stops being efficient and it's time to use something bigger? > Or > > in other words, how large are average SQLite installations in terms > of > > users, tickets, etc.? > > In my opinion, I would say that SQLite is appropriate for testing and > development work, where you have developers working on customizations > of > RT. I don't think SQLite is appropriate for production environments of > any size. But that's just me.
I'd have to completely with this. SQLite's complete lack of threading model means responding to a single request at a time. Simply put, if you have enough users that the possibility of multiple people requesting information at the same time, or a user request happening when an external ticket comes in (email via rt-mailgate etc.), then you're going to be causing users to stall, waiting. You may be able to get away with it for a small number of concurrent users (1-5 maybe) in a low volume environment, but if you're wanting to do anything serious with email coming in at any moment, then you'd be better off setting up a MySQL/PgSQL DB. The effort isn't much different. Stuart _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [email protected] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
