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 _______________________________________________ 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
