Hi All, I have a table field that is starting to have some performance issues. The indexes have been verified and there isn't a very large number of records being searched. When the form is opened I have an active link that refreshes the table. The display properties for the table field has Refresh on Entry Change checked. Looking in the 6.3 Applications - Basic Guide its say on page 246
For table fields, refreshes data when the request in which the table is embedded appears. Enable this mode if users must see the contents of the field whenever they access a request. To reduce performance impact, limit the use of this feature because each refresh causes a database search. I am not sure what this means. If it means I had doing a double search, one by Refresh on Entry Change and one by the active link refresh, please let me know. I have run database logging but only see the active link refresh. ARS 6.3 patch 20 Oracle 9.2 Thanks Mark Mark Brittain Remedy Developer, ITILv3 Foundation, CSI NaviSite, Inc. - A Time Warner Cable Company mbritt...@navisite.com<mailto:mbritt...@navisite.com> Office: 315.634.9337 Mobile: 315.882.5360 [cid:image001.gif@01CEDFAA.E70EE330] ________________________________ This E-mail and any of its attachments may contain Time Warner Cable proprietary information, which is privileged, confidential, or subject to copyright belonging to Time Warner Cable. This E-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this E-mail, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to this E-mail is strictly prohibited and may be unlawful. If you have received this E-mail in error, please notify the sender immediately and permanently delete the original and any copy of this E-mail and any printout. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
<<inline: image001.gif>>