AnsweredAssumed Answered

help with a slow script using replace field contents

Question asked by slaglemark on Jun 14, 2011
Latest reply on Jun 16, 2011 by philmodjunk

Title

help with a slow script using replace field contents

Post

hello, thanks for your time.

i am experiencing some major slowdown when running a particular script.

i am using a portal from a self-join relationship to display a list of data below some summary data in IWP.

to force the portal to show the found set from the first table instance, i have a field called PortalKey.  this field has a static value of 1.

the script performs a find, then sets the related PortalKey field from the other instance of the table to a value of 1.

thus, the portal shows me only the proper records. 

i then simply delete the value in PortalKey for all of the records whenever a user resets the search.

i am finding that this process is slooooow.  

is there a better way?

thanks!

Outcomes