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: Appropriate Uses For SQLite and it seems
like I should be fine, but wanted a 2nd opinion.
TIA
On Tue, Feb 28, 2006 at 04:41:54PM -0800, Nithin R. 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.
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.