ORACLE & PowerHouse 733d3

[Ronald W. Olenic]

This is a multi-part message in MIME format.
--------------D213BBA5C5E495E13BE2B999
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi Aci!

If your response time is up to 10 times slower, I would suspect that you
are missing some indexes (indices for the picky).  Unless you are
talking about 1 second to 10 seconds, a difference of that magnitude
(assuming that the new hardware is bigger better faster) usually means
you have gone from an indexed read to a sequential read.  Other
variables that can affect your performance would be CPU usage (swapping)
and disk IO.  

First check to see that all of the indexes have been created, then start
removing files from your access statement, and see if there is a
dramatic performance gain at one point.

Aci Polajnar wrote:
> 
> Hi there
> 
> After migrating to PowerHouse 733d3, we have much worse
> response time especialy with quiz reports. More than 10 times
> slower than before. Ph733d3 is now using SQL*net for accessing
> data base so we have tryed both, multi-threaded server and NON multi-threaded
> server, with same result. Are there any hints for tunning PH,
> database or SQL*net?
> 
> My platform is IBM RISC/6000, ORACLE 7.3.4 and PH733d3.
> 
> --
> -------------------------------------------------------------
> Aci Polajnar                  Tel   : +386(0)63 441144
> IS Consultant                 Fax   : +386(0)63 442036
> Razvojni Center Celje         e-mail: acip@rcc-irc.si
> 3000 Celje, Slovenia          URL   : http://www.rcc-irc.si
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
> This list is closed, thus to post to the list, you must be a subscriber.
--------------D213BBA5C5E495E13BE2B999
Content-Type: text/x-vcard; charset=us-ascii;
 name="olenicr.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Ronald W. Olenic
Content-Disposition: attachment;
 filename="olenicr.vcf"

begin:vcard 
n:Olenic;Ronald
x-mozilla-html:TRUE
org:Compuware
adr:;;;;;;
version:2.1
email;internet:ronolenic@bigfoot.com
title:Senior Systems Analyst
note;quoted-printable:The opinions expressed are my own, and as such are subject to change or  even complete reversal without notice=0D=0A
fn:Ronald Olenic
end:vcard

--------------D213BBA5C5E495E13BE2B999--

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