Hi all,
We are converting an old cobol system to PB. Some of the reports we
have to duplicate are pretty complex. I have 1 report that basically
prints out most of the data in the database.
It has an outer datawindow that joins 5 tables (2 are outer joins).
Than within it it has 4 nested datawindows. And in one of the 4
nested datawindows there are 10 nested datawindows. Right now when we
preview this dw in the dw painter it runs for a period of time then
fails and kicks me out of PB. Throughout the dws there are many dddws
decoding data.
We thought about flattening the data somehow with a stored proc but
because of the complexity of the data we are reporting on (many
multiple 1 to many relationships) this would be quite difficult.
The nested dws seem to be the performance problems. They are
re-retrieved for each dtl row in the outer dw. I believe any dddws on
the nested dws are also retrieved again.
Does anyone have any thoughts on how to tackle this problem? Any help
on this would be much appreciated!
We are using PB 6.5, PFC, and SQL anywhere 5.4. Base work stations
have 128 megs and are 233 mghtz or better.
Michael Swanson
Deloitte Consulting / DRT systems
[EMAIL PROTECTED]
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
