Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > Oracle
|
Oracle General Oracle database discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 6th, 2010, 09:29 AM
Authorized User
 
Join Date: Apr 2008
Posts: 85
Thanks: 10
Thanked 0 Times in 0 Posts
Default Problem with report generation time

Hi All,
I have created a application using vb.net which connect to Oracle database.What application does based on the user selection on the interface
Creates temporary table in the database and insert record into that table and then retreive records from the table and generates the csv file as a report.

It used to work fine no problem, But now since couple of days what is happening is evertime user is running application to generate the report time of
genration of the report is increasing by 30 second. When I restart the Oracle service then it takes normal time under 1 min when I run it forst time,when running second time with the same selection of information it keep increasing the report generation time.

Can some one please tell me where is the problem, is it due to less space in database of database got corrupt or something else ?

Any help or suggestion much appriciated.

Many Thanks
Nelly.

Last edited by nelly78; July 6th, 2010 at 09:30 AM.. Reason: Typo mistake





Similar Threads
Thread Thread Starter Forum Replies Last Post
automatic time table generation thava PHP How-To 0 January 19th, 2010 03:29 AM
Report Generation kotaiah Excel VBA 0 September 14th, 2006 08:26 AM
Report Generation Problem lushh Access VBA 2 September 5th, 2006 07:16 AM
report generation at run time ??? nabeelkhan Crystal Reports 1 May 21st, 2006 11:21 PM
Report Generation Application jmss66 VB How-To 2 February 9th, 2006 01:31 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.