All, Has anyone run into issues where search menus and other drop downs just hang because of inefficient SQL queries? A lot of the menus (the Product File Lookup form search menu for File ID for example), does a LIKE query against a huge number of records. The thing is, this is OOB with the DSL data load provided by BMC.
Is there a way to optimize these menus without a lot of custom work? I guess I can always reach out to the DBA to see if he can work some magic on indexes. I do see that the field being searched on is indexed on the form, but obviously it is not helping. Tauf Chowdhury | Forest Laboratories, Inc. Analyst, Service Management Informatics-Infrastructure Office: 631.858.7765 Mobile:646.483.2779 ********************************************************************** This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. 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, or the employee or agent responsible for delivering this e-mail to the intended recipient, 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 Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"