I want them to choose one of the records instead Typing it in and getting it wrong. It would better to do it another way instead of giving them a selection of all the records to choose from for sure!
Lisa -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Misi Mladoniczky Sent: Friday, June 10, 2011 9:20 AM To: arslist@ARSLIST.ORG Subject: Re: Performance issue on Menu Hi, If the data does not need to be 100% up to date, this seems like a good candidate for a nightly report? When it is useful for human to examine 22,000 lines when clicking on a char-menu or scrolling a table-field? If the person needs to find one specific line, it seems likely that you can do a multiple-tier selection of some kind? Best Regards - Misi, RRR AB, http://rrr.se > 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/teconnectivit >> y >> >[cid:image003.png@01CC2749.FBEC6050]<http://www.facebook.com/teconne >> >c >> tivity>[cid:image004.png@01CC2749.FBEC6050]<http://www.flickr.com/pho >> tivity>t >> os/teconnectivity/>[cid:image005.png@01CC2749.FBEC6050]<http://www.li >> n >> kedin.com/groups?gid=1591657>[cid:image006.png@01CC2749.FBEC6050]<htt >> p >> ://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" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"