OK, Sqlite will scale just as well on a single processor machine with few drives as any big RDBMS. If Sqlite was to take a turn to compete in areas it does not already dominate clearly, it would be in scale. If sqlite could take advantage of multiple processors and drives that would be huge, but again that adds a ton of complexity to the architecture of the database. As time goes on and AMD and Intel start pumping out 64-bit processors, we are going to see some really scalable Sqlite databases with NO additional complexities added to the code other than what you are already doing. So my point here is I see the database staying SIMPLE and FAST, and as hardware allows you can run much larger dbs.
Now, one thing to think about is grid computing. Ironically, Oracle, Secret (SQL) Server (as I call it), and the other major vendors are moving to a simpler model of distributing across multiple machines. Trying to scale their databases to expensive hardware is going out because it is so much cheaper to go out and get multiple mass produced machines and put them together to get massive parallel processing (and run Suse or Red Crap(oops I mean hat). If you were to head these other vendors off at the pass on this one, you would add the ability to simply distribute a database across machine boundaries. Some sort of Distributed Transaction Coordinator like in Secret Server would make Sqlite (as I put my finger on my mouth as in Austin Powers) 1 MILLION DOLLARS! Thanks, Allan -----Original Message----- From: D. Richard Hipp [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 7:13 AM To: [EMAIL PROTECTED] Subject: Re: [sqlite] web server use of SQLite D. Richard Hipp wrote: > > The www.sqlite.org website is run off of a single SQLite database. > Back before I implemented bandwidth throttling, the site would > sometimes get 50000 hits/day to pages that used the database. > Over the past 30 days, the www.sqlite.org website has seen 6 separate 10-minute bursts of activity with 250000 hits/day rates and many 1-minute bursts in the 450000 hits/day range. Rates in excess of 200000 hits/day have been sustained for a couple of hours on one event. (Many of the 1-minute and 10-minute burst records can be found within that two-hour episode.) These figures only count hits that accessed the database at least once. Images and static pages are not counted. -- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]