Slow performens

Mikael A Olesen mao@krifapost.dk
Mon, 18 Mar 2002 07:36:46 +0100


Hi Anders

There also seem to be a problem running PH/Oracle/HP3000 at least in some
older PH versions (8.19 C3).
We ran into serious problems a couple of years ago when we change some
database set from Image to
Oracle. It was ok in the testing process. But when we ran test in "real
life" the response time went from 2 sec
till about 5 minutes with 20 online users - and much worse with more
users!!

We had Oracle over and they found out that the problem was'nt on the Oracle
side. Then we contacted Cognos
and they told us that they had heard about it before and that it probably
would be fixed in the next PH version....!
But we have heard that one before and found another solution to the
problem.

Kind Regards

Mikael A. Olesen
Systemudvikler

--------------------------------------------
Tlf.: +45 8911 2390 (office)
Tlf.: +45 8745 0890 (home)
E-mail: mao@krifapost.dk
--------------------------------------------



                                                                                                                                       
                      Birkmose Anders                                                                                                  
                      Joon-Soo                 To:       powerh-l@lists.swau.edu                                                       
                      <anbik@wmdata.com        cc:                                                                                     
                      >                        Subject:  Slow performens                                                               
                      Sent by:                                                                                                         
                      powerh-l-admin@cu                                                                                                
                      be.swau.edu                                                                                                      
                                                                                                                                       
                                                                                                                                       
                      14-03-2002 17.03                                                                                                 
                                                                                                                                       
                                                                                                                                       




Running a PowerHouse application on an AIX-server against an
ORACLE database on a NT-server, seems to give a slow performens.

The reason for this setup is that the ORACLE database itself
runs faster on the NT server.

Is there anything i can do without changing my code to (Cursor access).
e.g. on the ORACLE client side or in the PowerHouse setup.

Regards
Anders Birkmose


= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.