Re: Performance issue on Menu

[Sathish Kumar]

Since you are in 7.1, and huge queries will cause application memory to 
increase and could even lead to crash when it reaches the threshold(2G for 
Windows for 4G for Unix enviornments)

I would recommend you to review/test the memory growth when such menu is 
developed, were it can be accessed by lot of users very frequently.

-Sathish

___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: Performance issue on Menu

[William Rentfrow]

However 
 
One of my current customers has 40,000+ sites.  Consequently the "Site+"
field pulls 120,000+ records because the way the application was
structured the Region/Site Group/Site menus do not just pull form site -
they pull from a cascading set of join forms that include things like
site aliases, etc.
 
The tiered menu system should help in this Instance - BUT - the best
practice view blow that philosophy out of the water.  There is specific
workflow in several places that set Region and Site Group to NULL when
you hit the "Site+" field.  In other places those fields aren't even on
the form.
 
4 minutes later you get your menu with120,000 records.  Believe it or
not they are laid out well enough that you can find your site
quicklybut there's some weird design in there.  We're still working
with BMC support and R&D on this issue.
 

William Rentfrow 
Principal Consultant, StrataCom Inc. 
wrentf...@stratacominc.com 
Blog: www.williamrentfrow.com 
O 715-592-5185 
C 715-410-8056 

 



From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of John Sundberg
Sent: Friday, June 10, 2011 10:21 AM
To: arslist@ARSLIST.ORG
Subject: Re: Performance issue on Menu


** Agreed - the menu is too large for actual use -- auto-complete would
be a great solution for both usability and performance. 

Also -- for fun -- it is good to look at this occasionally for
thoughts/inspiration...

http://developer.apple.com/library/mac/#documentation/UserExperience/Con
ceptual/AppleHIGuidelines/XHIGIntro/XHIGIntro.html



<http://developer.apple.com/library/mac/#documentation/UserExperience/Co
nceptual/AppleHIGuidelines/XHIGIntro/XHIGIntro.html> -John




On Jun 10, 2011, at 10:26 AM, Easter, David wrote:

** 

Another possibility (perhaps more forward looking) is to upgrade to AR
System 7.6.04 or later and utilize the auto-complete feature.  BMC has
tune the auto-complete to address this exact use case (a menu with a
very large number of items - like a customer list).  

Auto-complete was actually introduced in AR System 7.5.00, but the
performance increase for this use case was added in 7.6.04.  

28-Jan-2011 What's New: BMC Remedy Action Request System 7.6.04 PDF
<http://documents.bmc.com/supportu/documents/42/26/194226/194226.pdf> 

Enhanced auto-completion

The automatic complete feature is improved to handle large data sets in
search menus that are attached to a character field (for example, over
10,000 entries). This feature also minimizes unwanted searches.

For more information, see the Form and Application Objects Guide.

-David J. Easter

Manager of Product Management, Remedy Platform

BMC Software, Inc.

The opinions, statements, and/or suggested courses of action expressed
in this E-mail do not necessarily reflect those of BMC Software, Inc.
My voluntary participation in this forum is not intended to convey a
role as a spokesperson, liaison or public relations representative for
BMC Software, Inc.

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Jason Miller
Sent: Friday, June 10, 2011 07:07 AM
To: arslist@ARSLIST.ORG
Subject: Re: Performance issue on Menu

** 

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"  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: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 - Mi

Re: Performance issue on Menu

[John Sundberg]

Agreed - the menu is too large for actual use -- auto-complete would be a great 
solution for both usability and performance.

Also -- for fun -- it is good to look at this occasionally for 
thoughts/inspiration...

http://developer.apple.com/library/mac/#documentation/UserExperience/Conceptual/AppleHIGuidelines/XHIGIntro/XHIGIntro.html



-John




On Jun 10, 2011, at 10:26 AM, Easter, David wrote:

**
Another possibility (perhaps more forward looking) is to upgrade to AR System 
7.6.04 or later and utilize the auto-complete feature.  BMC has tune the 
auto-complete to address this exact use case (a menu with a very large number 
of items – like a customer list). 

 

Auto-complete was actually introduced in AR System 7.5.00, but the performance 
increase for this use case was added in 7.6.04. 

 

28-Jan-2011 What’s New: BMC Remedy Action Request System 7.6.04 PDF

 

Enhanced auto-completion

The automatic complete feature is improved to handle large data sets in search 
menus that are attached to a character field (for example, over 10,000 
entries). This feature also minimizes unwanted searches.

 

For more information, see the Form and Application Objects Guide.

 

-David J. Easter

Manager of Product Management, Remedy Platform

BMC Software, Inc.

 

The opinions, statements, and/or suggested courses of action expressed in this 
E-mail do not necessarily reflect those of BMC Software, Inc.  My voluntary 
participation in this forum is not intended to convey a role as a spokesperson, 
liaison or public relations representative for BMC Software, Inc.

 

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Jason Miller
Sent: Friday, June 10, 2011 07:07 AM
To: arslist@ARSLIST.ORG
Subject: Re: Performance issue on Menu

 

**

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"  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: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_attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_

_attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_

--
John Sundberg

Kinetic Data, Inc.
"Building a Better Service Experience"
Recipient of:
WWRUG10 Best Customer Service/Support Award
WWRUG09 Innovator of the Year Award

john.sundb...@kineticdata.com
651.556.0930  I  www.kineticdata.com










___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Re: Performance issue on Menu

[Easter, David]

Another possibility (perhaps more forward looking) is to upgrade to AR System 
7.6.04 or later and utilize the auto-complete feature.  BMC has tune the 
auto-complete to address this exact use case (a menu with a very large number 
of items - like a customer list).

Auto-complete was actually introduced in AR System 7.5.00, but the performance 
increase for this use case was added in 7.6.04.

28-Jan-2011 What's New: BMC Remedy Action Request System 7.6.04 
PDF<http://documents.bmc.com/supportu/documents/42/26/194226/194226.pdf>

Enhanced auto-completion
The automatic complete feature is improved to handle large data sets in search 
menus that are attached to a character field (for example, over 10,000 
entries). This feature also minimizes unwanted searches.

For more information, see the Form and Application Objects Guide.

-David J. Easter
Manager of Product Management, Remedy Platform
BMC Software, Inc.

The opinions, statements, and/or suggested courses of action expressed in this 
E-mail do not necessarily reflect those of BMC Software, Inc.  My voluntary 
participation in this forum is not intended to convey a role as a spokesperson, 
liaison or public relations representative for BMC Software, Inc.

From: Action Request System discussion list(ARSList) 
[mailto:arslist@ARSLIST.ORG] On Behalf Of Jason Miller
Sent: Friday, June 10, 2011 07:07 AM
To: arslist@ARSLIST.ORG
Subject: Re: Performance issue on Menu

**

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" 
mailto:lisa.ke...@te.com>> 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:arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>] On Behalf Of Misi 
> Mladoniczky
> Sent: Friday, June 10, 2011 9:20 AM
> To: arslist@ARSLIST.ORG<mailto: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_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"

Re: Performance issue on Menu

[Jason Miller]

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"  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:
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

Re: Performance issue on Menu

[Logan, Kelly]

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 S

Re: Performance issue on Menu

[Kemes, Lisa]

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]> 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"

Re: Performance issue on Menu

[Misi Mladoniczky]

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/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]> ://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"

Re: Performance issue on Menu

[Matt Reinfeldt]

Lisa,

 

How are you qualifying the search on the menu?  If needed, run a SQL log to
see what query is actually getting passed to the database, and work from
there.  Often, it's not what you'd expect.  Hopefully, you're doing
something on the front-end to narrow down what shows in that menu from 22k,
though!  

 

Good luck,

 

Matt

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Kemes, Lisa
Sent: Friday, June 10, 2011 7:40 AM
To: arslist@ARSLIST.ORG
Subject: Performance issue on Menu

 

** 

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

 <http://www.te.com/> Description:
http://www.tycoelectronics.com/images/socialmedia/smallTElogo.gif
www.te.com <http://www.te.com/>  


 <http://twitter.com/teconnectivity> Description:
http://www.tycoelectronics.com/images/socialmedia/twitter.png
<http://www.facebook.com/teconnectivity> Description:
http://www.tycoelectronics.com/images/socialmedia/facebook.png
<http://www.flickr.com/photos/teconnectivity/> Description:
http://www.tycoelectronics.com/images/socialmedia/flickr.png
<http://www.linkedin.com/groups?gid=1591657> Description:
http://www.tycoelectronics.com/images/socialmedia/linkedin.png
<http://www.youtube.com/teconnectivity> Description:
http://www.tycoelectronics.com/images/socialmedia/youtube.png

 

_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"
<><><><><><>

Re: Performance issue on Menu

[Kemes, Lisa]

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] ://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"

Re: Performance issue on Menu

[Misi Mladoniczky]

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]
> www.te.com
>
> [cid:image002.png@01CC2749.FBEC6050][cid:image003.png@01CC2749.FBEC6050][cid:image004.png@01CC2749.FBEC6050][cid:image005.png@01CC2749.FBEC6050][cid:image006.png@01CC2749.FBEC6050]
>
>
> ___
> 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"

Performance issue on Menu

[Kemes, Lisa]

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]
www.te.com

[cid:image002.png@01CC2749.FBEC6050][cid:image003.png@01CC2749.FBEC6050][cid:image004.png@01CC2749.FBEC6050][cid:image005.png@01CC2749.FBEC6050][cid:image006.png@01CC2749.FBEC6050]


___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
<><><><><><>