[Rails] Re: SQLite in small production environment

Nithin Reddy jashugan at gmail.com
Wed Mar 1 19:19:31 GMT 2006


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

The write rate will be very small. Only when products and
announcements are updated, or when distributors update their contact
information will there be a need to write to the database.

- Nithin


More information about the Rails mailing list