1 Reply Latest reply on Jun 15, 2012 2:31 PM by philmodjunk

    Slow Searches



      Slow Searches


      My database contains a lot fields and a lot of records. I have Filemaker Server but the searches are still pretty slow. Can I make some fields not be search to make the search faster? I really only need to search four fields and the rest are not something that will ever be searched for. Or is there a way to set it up though the Filemaker Server to have faster searches?

        • 1. Re: Slow Searches

          Normally, if you are entering search criteria in only 4 fields, the presence or absence of other fields in the same record should not affect the search speed.

          How many records are in the table of the layout where you perform your search?

          What type of criteria, typically, do you use in the search?

          Do you see a progress bar when you perform the search and it's slow? How is the progress bar labeled?

          Is the server on you local network or do you connect to it via the internet or VPN?