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..