That's probably what I'll have to end up doing (limiting the selection). I'll think of a different way (there are many ways to skin a cat) <-where did this saying come from anyway?
Anyway, just wondering if I was doing something wrong, but if this performance is as expected for 22,000+ records, I'll figure out another way to gather this data for the customer. Maybe I'll make them type in the first few letters and only bring back those records or something. Thanks!! Lisa -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Friday, June 10, 2011 8:55 AM To: arslist@ARSLIST.ORG Subject: Re: Performance issue on Menu Hi, If you want to load 22,000 records into your client, it will always take time. Would it not be possible to limit the selection? If you are loading all records, indexes are not important, as everything must be read anyhow. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. > 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 > lisa.ke...@te.com > MS 161-43 > P.O. Box 3608 > Harrisburg, PA 17105-3608 > > [cid:image001.gif@01CC2749.FBEC6050]<http://www.te.com/> > www.te.com<http://www.te.com/> > > [cid:image002.png@01CC2749.FBEC6050]<http://twitter.com/teconnectivity > >[cid:image003.png@01CC2749.FBEC6050]<http://www.facebook.com/teconnec > tivity>[cid:image004.png@01CC2749.FBEC6050]<http://www.flickr.com/phot > os/teconnectivity/>[cid:image005.png@01CC2749.FBEC6050]<http://www.lin > kedin.com/groups?gid=1591657>[cid:image006.png@01CC2749.FBEC6050]<http > ://www.youtube.com/teconnectivity> > > > ______________________________________________________________________ > _________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > 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"