[rt-users] Is SQLite no longer supported?

[Stuart Browne]

> -----Original Message-----
> From: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-
> bounces at lists.bestpractical.com] 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