Kees Nuyt wrote:
On Wed, 3 Oct 2007 15:39:06 +0200, you wrote:
I created an index on a TEXT column as I want to be able to
I noticed a large increase in the file size.
Looking at the binary of the file, I see that the index has a copy of all the
data being indexed.
1. Is this necassary?
2.
to referencing the original data.
Clive
John Stanton <[EMAIL PROTECTED]> on 05/10/2007 00:54:21
Please respond to sqlite-users@sqlite.org
To: sqlite-users@sqlite.org
cc:(bcc: clive/Emultek)
Subject: Re: [sqlite] Index size in file
Trevor Talbot wrote:
> On 10/4/07, Joh
On Wed, 3 Oct 2007 15:39:06 +0200, you wrote:
>
>
>
>I created an index on a TEXT column as I want to be able to
>I noticed a large increase in the file size.
>Looking at the binary of the file, I see that the index has a copy of all the
>data being indexed.
>1. Is this necassary?
>2. Is there a
Trevor Talbot wrote:
On 10/4/07, John Stanton <[EMAIL PROTECTED]> wrote:
A B-Tree index holds keys in sorted sequence. They are in random
sequence in the database. That requires holding the keys in the B-Tree
nodes.
Actually, it doesn't strictly require that; it could store references
to
[EMAIL PROTECTED] wrote:
> Regarding:
>
>>> Looking at the binary of the file, I see that the index has a copy of
>>> all the data being indexed.
>>> 1. Is this necassary?
>>>
>
> Unless you're programming for a cellphone or some other embedded gadget,
> you might want to calculate the
c: clive/Emultek)
Subject: RE: [sqlite] Index size in file
Regarding:
>>Looking at the binary of the file, I see that the index has a copy of
>>all the data being indexed.
>>1. Is this necassary?
Unless you're programming for a cellphone or some other embedded gadget,
yo
gt; on 04/10/2007 20:02:16
Please respond to sqlite-users@sqlite.org
To: sqlite-users@sqlite.org
cc:(bcc: clive/Emultek)
Subject: Re: [sqlite] Index size in file
A B-Tree index holds keys in sorted sequence. They are in random
sequence in the database. That requires holding the keys
if it is
possible to create an index in memory?
Clive
John Stanton <[EMAIL PROTECTED]> on 03/10/2007 17:36:58
Please respond to sqlite-users@sqlite.org
To: sqlite-users@sqlite.org
cc:(bcc: clive/Emultek)
Subject: Re: [sqlite] Index size in file
An index which does not hold keys is not an
An index which does not hold keys is not an index. If you don't want to
allocate space for indexing then you put up with slow performance and
use row searches.
[EMAIL PROTECTED] wrote:
I created an index on a TEXT column as I want to be able to
I noticed a large increase in the file size.
9 matches
Mail list logo