Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Categories
- 140.9K All Categories
- 103.7K Programming Languages
- 6.5K Assembler Developer
- 1.9K Basic
- 40K C and C++
- 2.9K C#
- 7.9K Delphi and Kylix
- 4 Haskell
- 9.7K Java
- 4.1K Pascal
- 1.3K Perl
- 2K PHP
- 549 Python
- 37 Ruby
- 4.4K VB.NET
- 1.6K VBA
- 20.8K Visual Basic
- 2.6K Game programming
- 316 Console programming
- 91 DirectX Game dev
- 1 Minecraft
- 112 Newbie Game Programmers
- 2 Oculus Rift
- 9K Applications
- 1.8K Computer Graphics
- 741 Computer Hardware
- 3.4K Database & SQL
- 535 Electronics development
- 1.6K Matlab
- 628 Sound & Music
- 257 XML Development
- 3.3K Classifieds
- 199 Co-operative Projects
- 198 For sale
- 190 FreeLance Software City
- 1.9K Jobs Available
- 603 Jobs Wanted
- 209 Wanted
- 2.9K Microsoft .NET
- 1.8K ASP.NET
- 1.1K .NET General
- 3.4K Miscellaneous
- 8 Join the Team
- 354 Comments on this site
- 70 Computer Emulators
- 2.1K General programming
- 187 New programming languages
- 627 Off topic board
- 205 Mobile & Wireless
- 77 Android
- 126 Palm Pilot
- 338 Multimedia
- 154 Demo programming
- 184 MP3 programming
- Bash scripts
- 27 Cloud Computing
- 53 FreeBSD
- 1.7K LINUX programming
- 370 MS-DOS
- Shell scripting
- 321 Windows CE & Pocket PC
- 4.1K Windows programming
- 941 Software Development
- 417 Algorithms
- 68 Object Orientation
- 92 Project Management
- 95 Quality & Testing
- 268 Security
- 7.7K WEB-Development
- 1.8K Active Server Pages
- 61 AJAX
- 4 Bootstrap Themes
- 55 CGI Development
- 28 ColdFusion
- 224 Flash development
- 1.4K HTML & WEB-Design
- 1.4K Internet Development
- 2.2K JavaScript
- 37 JQuery
- 306 WEB Servers
- 150 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
© 1997-2015 Programmersheaven.com - All rights reserved.