Deltinator
Programmer
Hi all,
ich have finished my first bigger report for Siebel, but
it is so slow, that it cannot be seriously used. I have
identified two unacceptably time consuming activities:
1) I use a Multiple Input Filter with 2 nested loops to
join 2 AcSingleLists in RAM. The report runs for hours!
I know the mathematical problem: Search x times in list
y, average number of y-records read... Is there a
faster way of joining in Actuate? Something like an
index available?
2) I can quickly scroll forward through a 13 page report,
but when I scroll more than 10 pages backwards, it
seems as if the whole report is re-executed!
Any ideas are appreciated,
Andreas
ich have finished my first bigger report for Siebel, but
it is so slow, that it cannot be seriously used. I have
identified two unacceptably time consuming activities:
1) I use a Multiple Input Filter with 2 nested loops to
join 2 AcSingleLists in RAM. The report runs for hours!
I know the mathematical problem: Search x times in list
y, average number of y-records read... Is there a
faster way of joining in Actuate? Something like an
index available?
2) I can quickly scroll forward through a 13 page report,
but when I scroll more than 10 pages backwards, it
seems as if the whole report is re-executed!
Any ideas are appreciated,
Andreas