[rt-users] sqlite

[Martin Kraus]

On Wed, Sep 23, 2009 at 10:50:40AM -0400, Jesse Vincent wrote:
> 
> 
> 
> 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.

with 300 tickets on a machine running on xen, it's been unusable. took about
15 seconds just to show a ticket. the problem was disk io. underlying disk
space was a hardware raid1 on SAS disks. now with mysql, it takes about 2
seconds to show a ticket.

mk