0

Ninox Cloud "Edit fields..."

When I select a field to edit, and click "▶︎ More options" I see at the bottom, next to the checkbox for Global search, there is another checkbox for Index. What happens when you have the Index checkbox checked? I tried to find something in your documentation, but have trouble learning more about it.

2 replies

null
    • Jorg
    • 5 yrs ago
    • Reported - view

    Dear Ivan, 

    The "Index" checkbox should only be used for fields that often used as key fields for a search. If check that box there will be created an index in internal list, that helps to speed up the search of that field. 

    If check the box in to much of the fields the result will be vise versa to the intention and slow down the database because of a hughe amount of data in the index lists.

    For that reason I would suggest to keep the option unchecked unless you have any performance problems with the search in your database or in select() functions and you know how to handle indices.

    Best, Jörg

    • Erik_Ivan_Bech
    • 5 yrs ago
    • Reported - view

    Thank you! 

Content aside

  • 5 yrs agoLast active
  • 2Replies
  • 829Views