Re: Performance degrade after migrate db from NT to HP-UX

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam>
Date: Sun, 18 Mar 2001 09:08:42 GMT
Message-ID: <3ab47988.11363514@news-server>

On Sun, 18 Mar 2001 10:36:11 +0800, "Eddy" <eddyng_at_netvigator.com> wrote:

>NT is 4K, HP-UX is 8K
>

That shouldn't be enough for so much diff. OK, assume you have some means (other than Powerbuilder) to execute SQL from outside the HP box. For example, in a workstation that can connect to both NT and HP, you have something like SQL*Plus. Now:
Pick up a typical SQL being used in Powerbuilder, one of the ones you know is running slower against the HP database. Now, run it in SQL*Plus against both systems. Do you still get the big diff?

You know of course what I'm trying to do here is isolate and identify the real reason of the problem?

Cheers
Nuno Souto
nsouto_at_bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Sun Mar 18 2001 - 03:08:42 CST