RE: [sqlite] Re: SQLite and Columnar Databases

2007-12-18 Thread Tom Briggs
Ahh yes, the obvious answer. Duh. Thanks. :) > -Original Message- > From: Trevor Talbot [mailto:[EMAIL PROTECTED] > Sent: Tuesday, December 18, 2007 8:27 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Re: SQLite and Columnar Databases > > On 12/18/0

Re: [sqlite] Re: SQLite and Columnar Databases

2007-12-18 Thread Trevor Talbot
On 12/18/07, Tom Briggs <[EMAIL PROTECTED]> wrote: >This implies that there are databases that provide multiple storage > mechanisms and allow users to choose between the options. Does such a > database exist? It may not be exactly what you had in mind, but see MySQL: http://dev.mysql.com/do

RE: [sqlite] Re: SQLite and Columnar Databases

2007-12-18 Thread Tom Briggs
> If a DBMS is smart enough, it can automatically pick the best storage > method for performance and you don't have to think about it. > > However, many DBMS are not that smart and so typically users find > themselves making explicit changes to their schemas, specifying the > storage method