Fields containing large amounts of text data, will generate large indexes, which can vastly increase file size. Then, FileMaker adds each unique word to the index with references to each record occurrence, making searching way faster.Īs nice as that sounds, you must be aware that too much indexing can be a bad thing. A word index is created by storing each unique word in a field. Word indexes can only be created for text fields and calculation fields that return a text result, where they are used for searches. Word indexesįileMaker Pro uses two different types of indexes: word indexes and value indexes. This is the best analogy for how indexing works in FileMaker, it stores small portions of data to act as references so that certain tasks can perform faster. This way, the user searches maybe a handful of pages rather than hundreds or even thousands of pages. When searching for a specific topic, you find it easily in the index at the back of the book, where it includes a list of page numbers that topic appears on.
Picture the index at the back of a big textbook. Indexes increase the speed of searches as well as support other features like sorting, using value lists and field validation.
FileMaker Pro uses indexes for searching and for joining related tables. If you are experienced in developing in FileMaker, you know you can create indexes, which are lists of the words or values in a field.
0 kommentar(er)
