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/teconnectivity
>> >[cid:[email protected]]<http://www.facebook.com/teconnec
>> tivity>[cid:[email protected]]<http://www.flickr.com/phot
>> os/teconnectivity/>[cid:[email protected]]<http://www.lin
>> kedin.com/groups?gid=1591657>[cid:[email protected]]<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"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
