Faster finds

[danjacoby]

I have to perform a find on about a dozen different fields, each of which pulls from a relationship so they can't be stored or indexed. With 12.000 records to search through, the process currently takes about 5 minutes, as the "unindexed records to search" dialog box runs for each field.

Anyone know a way to speed up the process?

[Keith M. Davie]

Allow User Abort [Off]

Freeze Window

Perform external subscript to find rec'sin db which contains the indexed and stored fields

Go To Layout which displays the find through the portals

::??

[Kurt Knippel]

As Keith had said...but you can either perform the find initially in the related DB or stick the find criteria into global fields and then use those to popluate the find request.

Since you are finding on related fields, I assume that what you actually want to find are records in the master file which match some criteria in the related file. For that I have two suggestions: once your find has been made in the related file, populate a multi-key with the values of the MasterRecordID in those found records, either via a loop or a copy all records, then you can simply GTTR back to the master DB; the other method is to make a field in the master DB which simply stores the values of those search fields, periodically updated, upon which you perform your finds directly on the master db.