[rt-users] sqlite

[Jesse Vincent]

On Wed, Sep 23, 2009 at 10:29:03AM -0400, Mauricio Tavares wrote:
> Tom Lahti wrote:
> >> Sorry. What I meant to say is "RT's SQLite support"  - I _love_ SQLite
> >> for all sorts of applications. multi-user apps with SQLite are totally
> >> doable -- you just need to be careful with write concurrency ;)
> > 
> > If you leave synchronous writes on, you're limited on transaction speed.  A
> > commit takes at least two full drive rotations, so for a 7200rpm drive you can
> > only do 60 transactions per second.  Not terribly scalable :)
> > 
> 	I am in a small shop (12 people tops). If we end up having 60 tickets 
> per minute, I would be happily amazed and glad to upgrade to mysql or 
> something else.

No, really, don't do that.  We haven't tested RT 3.x on SQLite in a
production environment. That's not a supported configuration.  I have no
idea how badly it might hurt you.

Jesse Vincent (RT's Architect)