ORACLE & PowerHouse 733d3

[Fares Esber]

 You may want to look at using Embedded SQL in PowerHouse; We've noticed a
much better performance with relational DB. That is, in QUIZ, instead of
using "ACCESS fillename1 LINK to filename2...", you'll use SQL DECLARE
CURSOR with a SQL SELECT Statement. This way, you'll have your table joins
and data retrieval executed in Oracle and passed back to PowerHouse for a
much better performance.


-----Original Message-----
From: Aci Polajnar
To: 'PowerHouse List'
Sent: 11/16/99 6:36 AM
Subject: ORACLE & PowerHouse 733d3

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.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.