On Thu, 2005-12-15 at 14:16 -0800, Kevin Brown wrote: > Paul J Stevens wrote: > > And I suspect 5.0 will be become a requirement for 2.3+ so we can > > start working with views, triggers, etc... > > Hmm...that would imply ditching SQLite, wouldn't it? > > Not that I have a problem with that, mind you.
Why? SQLite has subselects, transactions, views and triggers. It's also faster in most of the dbmail tests (largely: bulk inserts and long search statements) that I ran than Pg 7, Pg 8, and SQLite. It uses an optimal algorithm for COUNT(*), and can avoid touching the database when the indexes can supply all the data for a SELECT. It also has a query-plan generator/debugger- albeit not quite as nice as Pg. Historically, I've found it faster than Pg7 and MySQL 3 and 4 in most of my own applications, and I've even used it in a distributed database application. If I'm missing something... -- Internet Connection High Quality Web Hosting http://www.internetconnection.net/