I apologize if this has been asked before, but couldn''t search the forum-mailing-list bridge. It seems the search feature is currently disabled. 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. I''ve read this page: http://www.sqlite.org/whentouse.html and it seems like I should be fine, but wanted a 2nd opinion. TIA - Nithin
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
> 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