[Rails] Re: SQLite in small production environment

[Matthew Palmer]

On Tue, Feb 28, 2006 at 04:41:54PM -0800, Nithin Reddy wrote:
> I wanted to know if SQLite will work for my company in a production
> environment.
> 
> My company's current website gets about 15,000 hits/month. The most
> hits it ever got in a day was about 1,500.
> 
> I will be deploying my application on a shared server. The database
> shouldn't be very large: it's holding about a 1,000 records.

The size of the database and it's hit rate isn't as important as the write
rate -- how often is this database going to be updated?  SQLite's write
performance, especially with concurrent access, is fairly poor --
understandabe, considering the architecture.  If you're mostly doing reads,
though, SQLite will happily serve that sort of load without a hassle.

- Matt