indexing for the web

[timmy]

just a simple question.

is it worthwhile to index the 2 or 3 fields that i will be using to search, via the web.

thanks in advance.

[Anatoli]

Definitely, this is improving database performance, thus also web.

[Vaughan]

By default, FMP fields index themselves after they have had a find performed on them. Calculation fields that cannot be indexed -- those based on a global or related field -- cannot be indexed at all, so performaing finds on these is always slow.

If the field options have been set to never index, change them. Otherwise, the index has already been created.