help with a slow script using replace field contents
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?