AnsweredAssumed Answered

Sorting Records

Question asked by JulioSandoval on Dec 29, 2016
Latest reply on Dec 29, 2016 by siplus

I currently have an issue with such a big delay when I enter a layout with 300+ records and wait for them to be sorted.

At first, it was taking 20 seconds to sort.

 

My Sorting was like this:

related_table::name

related_table2::name

related_table3::name

 

I have the sorting like this now:

related_table::name

related_table2::name

related_table3::tableID

 

The above sorting cut my sort times to 6 seconds.

 

 

I keep reading that Filemakers issue when sorting records is that it's done on the client side, which requires the client machine to download all records. Hence, why once they are downloaded the first time, sorting after that is almost immediate.

 

Is there a way to make this go faster?

Is there a way to create a sorting table which sorts minimal fields and then is displayed in the proper layout already sorted?

 

Imagine if I had thousands of records? It would be a nightmare.

 

The records that are being displayed have Container Fields, Text Fields, Date Fields, Calculated Fields (unstored) and text fields.

 

Thank you all for your help.

Outcomes