7 Replies Latest reply on Apr 29, 2017 10:20 PM by user28271

    Disabling Quick Find

    user28271

      Looking for a miracle.

       

      I did not realize that quick-find was defaulted to on.  Is there a way to turn it off on all layout at once or do I have to go one by one?

        • 1. Re: Disabling Quick Find
          philmodjunk

          Layout by layout it is. You might consider hiding and locking the toolbar. It's pretty easy to set up a button bar with buttons for navigating records that copy/pasted from layout to layout.

          • 2. Re: Disabling Quick Find
            user28271

            The goal is reduce indexing.  I was told that any field with QuickFind on is automatically indexed.  File size is growing a little faster then I would like

            • 3. Re: Disabling Quick Find
              philmodjunk

              That, to my knowledge, is not the case.

              • 4. Re: Disabling Quick Find
                user28271

                OK well this is an import concept for me to understand.

                 

                1.     The more field I index the larger my file get.

                2.     Setting a Field for QuickFind indexes the field.

                 

                In your opinion are both of these incorrect?

                • 5. Re: Disabling Quick Find
                  philmodjunk

                  1 is correct in general terms, but AFAIK indexing is controlled at the data level, not the layout level. You can go into Manage Database, and turn indexing off for most fields.

                   

                  But it keep in mind that turning indexing off can negatively affect performance in a number of cases.

                  • 6. Re: Disabling Quick Find
                    BruceRobertson

                    I think you're completely on the wrong track.

                    Also: is your concern simply file size; or is it search performance?

                    Don't disable indexing.

                    Don't disable QuickFind.

                     

                    Setting a field to allow QuickFind does NOT by itself, cause the field to be immediately indexed.

                    If you ARE going to allow QuickFind to be used on a layout, be sure to select only the fields that are indexed and which are based on the TO used by the layout.

                     

                    One example of a problem is to have related fields and calculated fields set to allow QF.

                     

                    Let's say you have an unstored calc that displays the record number and found count.

                    It displays "Record 37 of 434 found, 5,000 total"

                    Setting up that field to allow QF will cause searches on that layout to be terrible.

                     

                    However - this does not address the part of your question regarding file size.

                    Unstored calcs do not cause file size problems.

                    Do you have fields with very large text blocks in them?

                    Do you have, for instance, custom audit-trail functions in the tables? These can produce enormous text blocks and if they are indexed then yes, there would be a problem.

                    • 7. Re: Disabling Quick Find
                      user28271

                      Thanks for the answer.  In a previous post on this board it was stated that Quick Find indexes the field which appears to be wrong.

                       

                      The system I conceded with is actually 24 years old, began in FM5 and has been updated and upgraded over and over and with all that data I try to keep indexing as tight as possible.  They enjoy having instant access to everything so archiving is a loosing argument.

                       

                      All good and thanks for saving me the wasted effort of turning QF off.