Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Categories
- 141.8K All Categories
- 104.8K Programming Languages
- 6.4K Assembler Developer
- 1.9K Basic
- 39.9K C and C++
- 4.3K C#
- 7.9K Delphi and Kylix
- 4 Haskell
- 9.6K Java
- 4.1K Pascal
- 1.3K Perl
- 2K PHP
- 523 Python
- 37 Ruby
- 4.4K VB.NET
- 1.6K VBA
- 20.8K Visual Basic
- 2.6K Game programming
- 312 Console programming
- 89 DirectX Game dev
- 1 Minecraft
- 110 Newbie Game Programmers
- 2 Oculus Rift
- 8.9K Applications
- 1.8K Computer Graphics
- 732 Computer Hardware
- 3.5K Database & SQL
- 525 Electronics development
- 1.6K Matlab
- 628 Sound & Music
- 257 XML Development
- 3.3K Classifieds
- 198 Co-operative Projects
- 189 For sale
- 189 FreeLance Software City
- 1.9K Jobs Available
- 601 Jobs Wanted
- 201 Wanted
- 2.9K Microsoft .NET
- 1.7K ASP.NET
- 1.1K .NET General
- 3.3K Miscellaneous
- 5 Join the Team
- 0 User Profiles
- 354 Comments on this site
- 62 Computer Emulators
- 2.1K General programming
- 187 New programming languages
- 612 Off topic board
- 177 Mobile & Wireless
- 51 Android
- 124 Palm Pilot
- 335 Multimedia
- 151 Demo programming
- 184 MP3 programming
- 0 Bash scripts
- 22 Cloud Computing
- 53 FreeBSD
- 1.7K LINUX programming
- 368 MS-DOS
- 0 Shell scripting
- 320 Windows CE & Pocket PC
- 4.1K Windows programming
- 906 Software Development
- 408 Algorithms
- 68 Object Orientation
- 89 Project Management
- 90 Quality & Testing
- 250 Security
- 7.6K WEB-Development
- 1.8K Active Server Pages
- 61 AJAX
- 2 Bootstrap Themes
- 55 CGI Development
- 19 ColdFusion
- 224 Flash development
- 1.4K HTML & WEB-Design
- 1.4K Internet Development
- 2.2K JavaScript
- 35 JQuery
- 290 WEB Servers
- 152 WEB-Services / SOAP
Improve the DB performance
G.Manivannan
Member Posts: 43
in Java
Hai,
I am maintaining one web application which is done in Java & Oracle 10g & Jasper reports(Reporting tool for Java).
We will be generating Monthly report or Daily report or Report between two Dates (Ex. Invoice Statements)
I am sending query to database which contains 4 sub queries and collecting data from at least 4 tables.
The time taking for query processing and showing report is almost 3 to 5 minutes.
Still I want to reduce the time in terms of seconds.
Here where the Database caching concepts will be implemented.
How to go-a-head to fix up this issue?
Can I use Stored Procedures for this?
If you know about Database Caching in Java & Oracle please guide me to implement.
I have searched a lot in Google, but I feel I didn't get any good article or code.
Thanks in Advance.
Regards,
Manivannan.G
I am maintaining one web application which is done in Java & Oracle 10g & Jasper reports(Reporting tool for Java).
We will be generating Monthly report or Daily report or Report between two Dates (Ex. Invoice Statements)
I am sending query to database which contains 4 sub queries and collecting data from at least 4 tables.
The time taking for query processing and showing report is almost 3 to 5 minutes.
Still I want to reduce the time in terms of seconds.
Here where the Database caching concepts will be implemented.
How to go-a-head to fix up this issue?
Can I use Stored Procedures for this?
If you know about Database Caching in Java & Oracle please guide me to implement.
I have searched a lot in Google, but I feel I didn't get any good article or code.
Thanks in Advance.
Regards,
Manivannan.G
Terms of use / Privacy statement / Publisher: Lars Hagelin
Programmers Heaven articles / Programmers Heaven files / Programmers Heaven uploaded content / Programmers Heaven C Sharp ebook / Operated by CommunityHeaven LLC
© 1997-2015 Programmersheaven.com - All rights reserved.