All fields indexed.

Questions and suggestions for the CC Calendar product.
Posts: 7
Joined: Sun May 30, 2004 4:45 pm
PostPosted: Sun May 30, 2004 4:55 pm
Hi guy, CC Calendar looks really cool.

I am no expert with FM, but I am wondering why all fields of Appointments.fp5 are indexed. Isn't there a perfomance penalty? Is it really neccessary to index every field?
SeedCode Staff
SeedCode Staff
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Mon May 31, 2004 7:04 am
Hello Ross,

(Thanks for registering with the forum.)

There are only 6 data fields in Appointments.fp5 and 3 of these (ApptKeyDate, ApptKeyInitials, and ApptPrimeIDX) have to be indexed because they are used in relationships. The others are indexed to make it easier to perform finds on these fields.

Indexing does result in a performance penalty when it comes to importing records into a file (where they must be indexed as well as imported) and there are some file size constraints when considering to index a field.

However, from the standpoint of a user, however, indexing results in improved performance when it comes to searching as FileMaker searches (and sorts) indexed fields much more quickly.

HTH,

John
John Sindelar
SeedCode

Return to CC Calendar (FM6)

Who is online

Users browsing this forum: No registered users and 4 guests

(855) SEEDCODE
[email protected]
Follow us: