Lisa,
How are you qualifying the search on the menu? If needed, run a SQL log to see what query is actually getting passed to the database, and work from there. Often, it's not what you'd expect. Hopefully, you're doing something on the front-end to narrow down what shows in that menu from 22k, though! Good luck, Matt From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Kemes, Lisa Sent: Friday, June 10, 2011 7:40 AM To: [email protected] Subject: Performance issue on Menu ** I have a table with about 22,000 records. I have a unique index on 2 field on this table. On another form I have a Character field that connects via a menu to these records. Even though I have an index, it takes a good 40 seconds for the menu item to show all of the records when activated. Is there any way to increase the performance on this? Looks like it works this way on the desktop client and the midtier. ARS 7.1 p7 Windows 2003 Oracle 10g Lisa Kemes AR System Developer TE Information Systems Global Infrastructure and Ops +01 717 810 2408 tel +01 717 602 9460 mobile [email protected] MS 161-43 P.O. Box 3608 Harrisburg, PA 17105-3608 <http://www.te.com/> Description: http://www.tycoelectronics.com/images/socialmedia/smallTElogo.gif www.te.com <http://www.te.com/> <http://twitter.com/teconnectivity> Description: http://www.tycoelectronics.com/images/socialmedia/twitter.png <http://www.facebook.com/teconnectivity> Description: http://www.tycoelectronics.com/images/socialmedia/facebook.png <http://www.flickr.com/photos/teconnectivity/> Description: http://www.tycoelectronics.com/images/socialmedia/flickr.png <http://www.linkedin.com/groups?gid=1591657> Description: http://www.tycoelectronics.com/images/socialmedia/linkedin.png <http://www.youtube.com/teconnectivity> Description: http://www.tycoelectronics.com/images/socialmedia/youtube.png _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
<<image001.gif>>
<<image002.png>>
<<image003.png>>
<<image004.png>>
<<image005.png>>
<<image006.png>>
