Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Art S. Kagel — — source: Informix-list mailing list archive (1991-1998)
Tim Jones wrote:
[SNIP]
> Since going to 7.3 the performance of the PeopleSoft databases have
> improved in some cases but severely degraded in other cases. We have
> also seen poor performance in our internal custom app which has been
> fine for years in regards to some joins on unindexed columns.
The phrase 'going to 7.3' is the key!
One of the things to look at is correlated sub-query behavior. IDS 7.3
includes code to unwind correlated sub-queries into simple joins in
the optimizer. This can result in significant performance improvement
if there are indexes available to support the resulting join condition.
If there are no such indexes on the tables involved there can be
noticable performance degradation. Just what you are seeing.
PeopleSoft code is know to use correlated sub-queries extensively. The
newest versions apparently added the missing indexes which you will
need to do also.
Art S. Kagel
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.