As Misi noted, a multi-tiered menu could be very helpful here – if you have indexes declared, those same datapoints should be useful as groupings as well for a multi-tiered menu. Or they could be separate elements set by the customer for the search to narrow the selection and make the query faster. These could be tiered elements like Product Categorization uses, in a multi-tiered menu or set of menus, or separate elements like Incident Matching (customer name, location, priority, etc) on a control panel with a list of query results in a table below.
Perhaps some of these datapoints could be set by the system from what is known about the user; without knowing the data involved it's hard to guess, but an example would be showing by default sites that are in the same state as the customer, or issues that are associated with the laptop the customer owns, or the top 10, 20, 100 choices made by similar customers. This could also let you present most of the desired customer choices without having to do an unqualified query. Kelly Logan, Sr. Systems Administrator (Remedy), GMS ProQuest | 789 E. Eisenhower Parkway, P.O. Box 1346 | Ann Arbor MI 48106-1346 USA | 734.997.4777 kelly.lo...@proquest.com<mailto:kelly.lo...@proquest.com> www.proquest.com ProQuest...Start here. 2010 InformationWeek 500 Top Innovator P Please consider the environment before printing this email. This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender, and delete the message from your computer. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa Sent: Friday, June 10, 2011 9:25 AM To: arslist@ARSLIST.ORG Subject: Re: Performance issue on Menu 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<mailto:lisa.ke...@te.com> >> MS 161-43 >> P.O. Box 3608 >> Harrisburg, PA 17105-3608 >> >> [cid:image001.gif@01CC2749.FBEC6050]<mailto:[cid:image001.gif@01CC2749.FBEC6050]><http://www.te.com/> >> www.te.com<http://www.te.com/<http://www.te.com%3chttp:/www.te.com/>> >> >> [cid:image002.png@01CC2749.FBEC6050]<mailto:[cid:image002.png@01CC2749.FBEC6050]><http://twitter.com/teconnectivit >> y >> >[cid:image003.png@01CC2749.FBEC6050]<mailto:[cid:image003.png@01CC2749.FBEC6050]><http://www.facebook.com/teconne >> >c >> tivity>[cid:image004.png@01CC2749.FBEC6050]<mailto:[cid:image004.png@01CC2749.FBEC6050]><http://www.flickr.com/pho >> tivity>t >> os/teconnectivity/>[cid:image005.png@01CC2749.FBEC6050]<mailto:[cid:image005.png@01CC2749.FBEC6050]><http://www.li >> n >> kedin.com/groups?gid=1591657>[cid:image006.png@01CC2749.FBEC6050]<mailto:[cid:image006.png@01CC2749.FBEC6050]><htt >> p >> ://www.youtube.com/teconnectivity> >> >> >> _____________________________________________________________________ >> _ _________ UNSUBSCRIBE or access ARSlist Archives at >> www.arslist.org<http://www.arslist.org> >> attend wwrug11 www.wwrug.com<http://www.wwrug.com> ARSList: "Where the >> Answers Are" >> > > ______________________________________________________________________ > _________ UNSUBSCRIBE or access ARSlist Archives at > www.arslist.org<http://www.arslist.org> > attend wwrug11 www.wwrug.com<http://www.wwrug.com> ARSList: "Where the > Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org<http://www.arslist.org> attend wwrug11 www.wwrug.com<http://www.wwrug.com> ARSList: "Where the Answers Are"
