Maximo Wire - The IBM Maximo Help & Discussion Forum
May 20, 2012, 11:02:18 am *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: Welcome to Maximo Wire, the IBM Maximo help forum. Feel free to register and ask any Maximo related questions you like.
 
  Home Help Search Login Register  
*
Pages: [1]   Go Down
  Print  
Author Topic: Speed - Custom Home screens slow  (Read 482 times)
0 Members and 1 Guest are viewing this topic.
Steven
Newbie
*

Karma: 0
Posts: 1


View Profile
« on: December 29, 2010, 02:09:57 pm »

Hi,

I am system administrator in a company that runs Maximo 6.2.5 on weblogic 8.1 (4 servers in cluster) with an Oracle rac database.
I am not a maximo expert but neverteless currently investigating complaints about slowness.
I've upped the logging levels in our test env. and the first thing I've noticed is the excessive amount of database queries.
One users home screen does about 1300 "select * from ......." queries. It looks like 4-5 per line of data displayed on his screen.
With each querry taking about 3-10 miliseconds this screen takes between 6 and 10 seconds to load.
Since I have no frame of reference (only from the guys that did the customisations here and who say this is normal maximo behaviour) I came here to ask: Is this normal?
2nd question. Anyone know of a way (or tool) to meassure load times. I've been experimenting with wget but can't get past the maximo auth screen.

A small section from the log loading one of these screen, notice the timestamps:
--------------
29 Dec 2010 13:37:17:057 [INFO] USER = (1088) SPID = (590)  app (null) object (PERSONGROUPTEAM) :select * from persongroupteam    where persongroup in (select persongroup  from persongroup where xgrouptype ='PLANNER' and xcenter='2111') and resppartygroup='1088'
29 Dec 2010 13:37:17:060 [INFO] USER = (1088) SPID = (590)  app (null) object (PERSONGROUPTEAM) :select * from persongroupteam    where persongroup in (select persongroup  from persongroup where xgrouptype ='GKI' and xcenter='2111') and resppartygroup='1088'
29 Dec 2010 13:37:17:063 [INFO] USER = (1088) SPID = (590)  app (null) object (PERSONGROUPTEAM) :select * from persongroupteam    where persongroup in (select persongroup  from persongroup where xgrouptype ='CHEF' and xcenter='2111') and resppartygroup='1088'
29 Dec 2010 13:37:17:066 [INFO] USER = (1088) SPID = (590)  app (null) object (GROUPUSER) :select * from groupuser    where groupname='URNADM' and userid='1088'
29 Dec 2010 13:37:17:075 [INFO] USER = (1088) SPID = (590)  app (null) object (PERSONGROUPTEAM) :select * from persongroupteam    where persongroup in (select persongroup  from persongroup where xgrouptype ='PLANNER' and xcenter='2111') and resppartygroup='1088'
29 Dec 2010 13:37:17:077 [INFO] USER = (1088) SPID = (590)  app (null) object (PERSONGROUPTEAM) :select * from persongroupteam    where persongroup in (select persongroup  from persongroup where xgrouptype ='GKI' and xcenter='2111') and resppartygroup='1088'
29 Dec 2010 13:37:17:080 [INFO] USER = (1088) SPID = (590)  app (null) object (PERSONGROUPTEAM) :select * from persongroupteam    where persongroup in (select persongroup  from persongroup where xgrouptype ='CHEF' and xcenter='2111') and resppartygroup='1088'
29 Dec 2010 13:37:17:084 [INFO] USER = (1088) SPID = (590)  app (null) object (GROUPUSER) :select * from groupuser    where groupname='URNADM' and userid='1088'
Logged
Ethen
Global Moderator
Sr. Member
*****

Karma: 16
Posts: 302



View Profile WWW
« Reply #1 on: December 29, 2010, 02:58:07 pm »

Hi,
Maximo uses these kind of queries to show the screen, buttons and select actions apart from records.
These kind of running sqls are common for maximo as everything  like what to display,  how to display etc is taken from database. Even the application display (user interface) is taken from database.

You have set your sql logging level as Info, thats why it logs so much information in logs which might slow down the performance a bit.
Try setting it as some higher level like ERROR.

No idea about database monitoring. Maybe some DB admin can  help on this.
Logged

regards,

Ethen...
Pages: [1]   Go Up
  Print  
 
Jump to:  

Recent

TinyPortal v1.0 beta 4 © Bloc
Powered by MySQL Powered by PHP Powered by SMF 1.1.15 | SMF © 2011, Simple Machines Valid XHTML 1.0! Valid CSS!