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
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:
> 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
At 6:59 AM +0530 12/18/07, Yuvaraj Athur Raghuvir wrote:
Thanks for the interesting discussion. What I got so far is summarized
below:
1) Row based versus Column based storage is an implementation detail.
2) SQL used for access is independent of storage mechanism adopted.
3) Row based storage
Hello,
Thanks for the interesting discussion. What I got so far is summarized
below:
1) Row based versus Column based storage is an implementation detail.
2) SQL used for access is independent of storage mechanism adopted.
3) Row based storage with indices on all columns reaches read performance
5 matches
Mail list logo
