Home : Performance issues while loading Service Queues, Spread Report SQL Results and SQL Console Window
Q12578 - KNOWNISSUE: Performance issues while loading Service Queues, Spread Report SQL Results and SQL Console Window

There is a known issue in the Hach WIMS client where the Ado Calc, GNR and Email queues take a long time to load. Also affected are the SQL Result location feature in the Spread Report Designer and Admin Console's SQL Console window. This is especially apparent in large systems with a large number of schemas and databases, running on Oracle Backend.

Symptoms:

Any of the following:

  • The above mentioned queue windows a take a long time to load (2-10 minutes).
  • The Locate -> SQL Result window takes a long time to load (2-10 minutes) in the Hach WIMS Spread Designer.
  • The Admin Console -> SQL Console window takes a long time to load (2-10 minutes).

Work Around:

As of Hach WIMS 7.0.9, a Super user can set the Utilize Query Builder [General Setting] to "0" in the Hach WIMS Admin Console .  This setting will disable the loading of the schemas into the query builder.  This renders the query building portion of these windows unusable; however, this will greatly decrease the loading times for the above listed windows.

 

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 10/2/2009 2:47 PM.
Last Modified on 12/28/2009 11:58 AM.
Last Modified by Jan Bob.
Article has been viewed 2933 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article