Even if I have indexed all the data in the fields I search for, the search process will do some time. Is there something I can do to make this faster?
As in all databases try to avoid having all field as indexed. Just have the one that you know you will be searching on. In FileMaker you can choose to index when you search in field options.
A database is never slow from start. There could be numerous reasons why your database is slow
To many fields in the table
To many calculated fields
Searching in a related field
I am indexing only the fields that am searching on
What about the layout you are search on?
Do you have:
many portals on the same layout as you are searching on?
many calculations/summaries depending on fields in layout?
I have only one portal that showing the result that is searched on on the same layout. not many calculations, no conditinals formatting. some script triggers across this layout.
Presentation of the data once the find is complete IS something you can influence. See Johans suggestions to look at possible bottlenecks in the layout.
I would build a portal to show search result. I rather show result (if more then one record in list view, else portrait view). If you have many records a portal will never be fast.
customer has very spesific ideas on how this is going to look. and a list view under the search parameters would not be possible
I have three fields on Footer part above list where I have triggers executing each time I enter information into either of the fields making a list appear out of each letter I enter. Looks very good and works great.
What you are trying to do will always be slow if you have many records.
Either you got to convince your customer to re-think or they have to buy that it is slow
Yes I have alot for records.
In the advanced training series this tips is explained:
How to filter with relationship?
Portal filtering will never be as fast as a list that you search in.
slaekke wrote: How to filter with relationship?
Create a new relationship to a new Table Occurrence (TO) and include the filtering criteria in the relationship.
Portal filtering is typically a very slow process, if there are any significant number of records.
..and include the filtering criteria in the relationship.
Do you mean the sort record in the Edit relationship dialog?
Do not add sorting into your relationship. Do Go to related record and there add the Sort script step with the sorting of your choice
But that doesn't isolate only the most recent record, like the OP said he wanted...
Oops! Sorry; wrong thread!
Retrieving data ...