We have a few Remedy systems we work with here. One is an older system that was on 6.0x. It is being replaced within the year but for a few reasons we needed to upgrade it to 6.3 patch 25. It is running on Solaris. Since the upgrade some previously fine code is quite slow - but no code changes were made. One item in particular is quite slow. There is an AL "Set Fields" action doing a lookup to a join form. This AL has the option of "If Multiple requests match/Use first matching request". In the client side API log I can see the API fetching and returning all of the entries that match the query (+GLE and -GLE X the number of entries) - not just the first one. This whole process takes about a minute - but the first fetch only takes < 1 second. What's up with that? Isn't "Use first matching request" supposed to only fetch one record? William Rentfrow Principal Consultant, StrataCom Inc. [email protected] 701-306-6157 C
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
