Indexing

Would appreciate a quick explanation regarding the differences between
'minimal' and 'full.

The help file provides official definitions, of course, but I don't
really understand the practical ramifications of the two options.

Thanks heaps, Gareth
Gareth.Denyer [ Do, 25 Oktober 2007 02:46 ] [ ID #1854257 ]

Re: Indexing

On Oct 24, 5:46 pm, Gareth.Den... [at] gmail.com wrote:
> Would appreciate a quick explanation regarding the differences between
> 'minimal' and 'full.
>
> The help file provides official definitions, of course, but I don't
> really understand the practical ramifications of the two options.
>
> Thanks heaps, Gareth

It sort of works like this:

Suppose you have a text field containing "this field contains text".

In minimal, just one index entry is created, for the entire field,
"this field contains text", and if you think of the index like a
dictionary it will be under the T's.

In "All", an index entry is created for each word -- "this", "field",
"contains"... etc and 2 references to the record will be stored under
the T's, one under the F's, and one under the C's.

Please note the above is a bit of an over simplification, but I hope
it gets the idea accross.

For all other field types (ie... not 'text', minimal and all do the
same thing).

-cheers,
Dave
d-42 [ Mo, 29 Oktober 2007 04:54 ] [ ID #1856873 ]

Re: Indexing

On Oct 29, 1:54 pm, d-42 <db.pors... [at] gmail.com> wrote:
> On Oct 24, 5:46 pm, Gareth.Den... [at] gmail.com wrote:
>
> > Would appreciate a quick explanation regarding the differences between
> > 'minimal' and 'full.
>
> > The help file provides official definitions, of course, but I don't
> > really understand the practical ramifications of the two options.
>
> > Thanks heaps, Gareth
>
> It sort of works like this:
>
> Suppose you have a text field containing "this field contains text".
>
> In minimal, just one index entry is created, for the entire field,
> "this field contains text", and if you think of the index like a
> dictionary it will be under the T's.
>
> In "All", an index entry is created for each word -- "this", "field",
> "contains"... etc and 2 references to the record will be stored under
> the T's, one under the F's, and one under the C's.
>
> Please note the above is a bit of an over simplification, but I hope
> it gets the idea accross.
>
> For all other field types (ie... not 'text', minimal and all do the
> same thing).
>
> -cheers,
> Dave

Brilliantly explained, Dave.... thanks very much!!!

Full it is, then!!!

Cheerio, GAreth
Gareth.Denyer [ Mo, 29 Oktober 2007 09:09 ] [ ID #1856875 ]
Datenbanken » comp.databases.filemaker » Indexing

Vorheriges Thema: Play sounds stored in container fields in FM8.5pro.adv.
Nächstes Thema: pb with FMP Ad server 9 & Apache on Win XP