An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] Index size in file
Let's assume that my whole database can be in the cache. If my indexes have
duplicate data, then I will either need a bigger cache or have to page out
row
data in favour of index data.
In that case it will either be sl
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. I
posed 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
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 w
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 t
[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 co
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,
you m
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 cost (on the margin) of the disk storage
for the estima
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 the keys. An obvious
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
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 index. If you
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.
L
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 way to keep the index only in memory and not in the file.
"Andre du Plessis" <[EMAIL PROTECTED]> wrote:
> I have a question on index size, I have a table that by doing some
> testing the DB have grown to 250MB, might not seem too large, as the
> table have 4million records in it. But for this DB this table would grow
> a lot larger than that. So I did som
I have a question on index size, I have a table that by doing some
testing the DB have grown to 250MB, might not seem too large, as the
table have 4million records in it. But for this DB this table would grow
a lot larger than that. So I did some tests with a simple table 3 fields
FIELD1 is a inte
16 matches
Mail list logo
