carlsson

Sorting is extremely much slower on related recordes

Discussion created by carlsson on Oct 19, 2016
Latest reply on Oct 20, 2016 by OCDilla

Working with related records in Filemaker have always been slow, but now I'm wondering....

 

I have a table with 6.000 records containing Orders and related Clients.

 

Sorting on the related Client Name takes a couple of minutes.

If I lookup the Client Name in the Order Table and sort on that it takes 1/10th of a second.

 

WTF?!

 

Something must be seriously wrong... All fields involved are indexed, and there's nothing strange really. As I mentioned, Filemaker is not very good at handling related data, but I don't know if I have noticed it this bad before...!?

 

To use a lookup is bad in soo many ways, and I don't want redundant data!

 

Any ideas?

 

[FM Server and clients are version 15]

Outcomes