Our project has a report generation section which is giving me troubles..
Our front end is java and back end is oracle with C++ as the middle tier
and we r using sockets for client - server communication.. We have implemented
Pro C method 4 for executing oracle queries from C++...

But report generation is very slow...At times when too many joins and decode
statements are involved it takes upto 20-30 minutes to create reports.

If u hve any tips on improving the scenario... please help me..

Regards
Tom

02-08-2002, 07:07 AM

MarkN

Re: Tips for fast creation of reports from oracle database

Typically when you have many joins, you probably should be doing subreports
instead.

Some times large reports take time and they need to be run in batch mode.

Have you been able to pin point where the bottle neck is? If it is the persistence
tier, then do subreports and/or check your indexes.

Mark

"Tom" <javadst@yahoo.com> wrote:
>
>Dear friends...
>
>Our project has a report generation section which is giving me troubles..
>Our front end is java and back end is oracle with C++ as the middle tier
>and we r using sockets for client - server communication.. We have implemented
>Pro C method 4 for executing oracle queries from C++...
>
>But report generation is very slow...At times when too many joins and decode
>statements are involved it takes upto 20-30 minutes to create reports.
>
>If u hve any tips on improving the scenario... please help me..
>
>Regards
>Tom