[rt-users] sqlite

[Martin Kraus]

On Tue, Sep 22, 2009 at 11:40:03AM -0700, Tom Lahti wrote:
> > SQLite is primarily intended for development and testing environments.
> > It's not well-suited to a multi-user production environement for RT.
> 
> Actually, I think SQLite's mission is to provide a lightweight database for
> individual use applications.  It's used by a lot of such things such as Apple
> Mail, Safari, Firefox, Google Gears, and the Skype client.  But it certainly
> isn't robust enough for the enterprise side of things.  Google Gears on SQLite
> sure, but Google itself?  Skype client yes, but Skype servers?  Not gonna happen.

RT is very slow when using sqlite. I've installed rt3.6 from debian with
sqlite and after about 300 tickets, I was forced to go through a painful
process of migrating data to mysql. With mysql rt is about 10 times faster.

mk