NancyAdelman

Slow searching with ESS

Discussion created by NancyAdelman on Feb 26, 2014
Latest reply on Feb 28, 2014 by NancyAdelman

I have a FM 13 database with an ESS table, hosted by FM Server 13. The ESS table has a foreign key that is related to a FileMaker table primary key.

 

There are records in the ESS table that do not have a corresponding record in the FileMaker table. I want to find those records and delete them. I put the primary key from the FM related table on the ESS layout. The problem is that there are about 150,000 records in the ESS table and in the FM table and the find was too slow. I cancelled it after it processed for almost an hour. I have no idea how long it might have taken or if it ever would have finisihed..

 

Are there any suggestions for doing this?

 

Thank you.

 

Nancy

Adelman Databases

nancy@adelmandatabases.com

Outcomes