Form a UI design perspective that is kind of harsh; here's your 22,000 records, select one. Unless you have a really good drill down tier structure to hide many of the values that do not apply it is likely people would pick the wrong value out of frustration.
You are already seeing the performance impact in the amount of time it takes to open the menu but think about why. That is 22k records being sent over the wire and being stored in memory on the client's computer. With modern computers and a strong LAN this probably isn't much of an issue but will that be the case for all of your users? Can you give us a little more detail about your requirements? I am sure the community could help with a solution :) Jason On Jun 10, 2011 6:25 AM, "Kemes, Lisa" <[email protected]> wrote: > 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: [email protected]] On Behalf Of Misi Mladoniczky > Sent: Friday, June 10, 2011 9:20 AM > To: [email protected] > 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:[email protected]] On Behalf Of Misi Mladoniczky >> Sent: Friday, June 10, 2011 8:55 AM >> To: [email protected] >> 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 >>> [email protected] >>> MS 161-43 >>> P.O. Box 3608 >>> Harrisburg, PA 17105-3608 >>> >>> [cid:[email protected]]<http://www.te.com/> >>> www.te.com<http://www.te.com/> >>> >>> [cid:[email protected]]<http://twitter.com/teconnectivit >>> y >>> >[cid:[email protected]]<http://www.facebook.com/teconne >>> >c >>> tivity>[cid:[email protected]]<http://www.flickr.com/pho >>> tivity>t >>> os/teconnectivity/>[cid:[email protected]]<http://www.li >>> n >>> kedin.com/groups?gid=1591657>[cid:[email protected]]<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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
