HershHiltonHead

Speed up a Summary

Discussion created by HershHiltonHead on Jan 22, 2018
Latest reply on Jan 31, 2018 by mike_wallace_rcc

   I have a table with 115,000+ Drug Name records.  One fields in the table has a calc using the middle function

as follows:

"Middle ( Drug Name ; 1 ; 1 ) & "¶" &

Middle ( Drug Name ; 1 ; 2 ) & "¶" &

Middle ( Drug Name ; 1 ; 3 ) & "¶" &

Middle ( Drug Name ; 1 ; 4 ) & "¶" &

Middle ( Drug Name ; 1 ; 5 ) & "¶" &

Middle ( Drug Name ; 1 ; 6 ) & "¶" &

Middle ( Drug Name ; 1 ; 7 ) & "¶" &

Middle ( Drug Name ; 1 ; 8 ) & "¶" &

Middle ( Drug Name ; 1 ; 9 ) & "¶All"

 

The link to that is a global. I have a summery field set to count the "related finds" called "sCountName"

I have the user type in the name letter by letter and the portal refreshes with as expected.

The trigger I use on the global is set to display at dialog when a drug name is not found as entered "sCountName" = 0

The summary field recounts this each time they log on to the solution (it hosted on FM Server)

 

Any thoughts on how to remove this slow re-counting that occurs from time to time?

 

Any help is welcomed and appreciated.

 

TIA

 

M Hershinger

Outcomes