Tips for fast creation of reports from oracle database


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Tips for fast creation of reports from oracle database

  1. #1
    Tom Guest

    Tips for fast creation of reports from oracle database


    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

  2. #2
    MarkN Guest

    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



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center