Home » Developer & Programmer » Forms » report called from form is taking long time to print (forms 10g)
report called from form is taking long time to print [message #412714] Fri, 10 July 2009 14:34 Go to next message
nastyjillu
Messages: 211
Registered: February 2009
Senior Member
Hi, i have a form.
in the form, when i click the 'print' button, it will print a report.

problem is its taking 10 minutes to print.
if i run the report in report builder its taking 4 minutes to print. then why is it taking long time to print from form ??

the procedure which calls report is having code which checks for default printer and does some validation to find the printer,server,location etc.
thats all. then why should it take long time to print??

even if the data is very less, its taking same long time

thanks
jillu
Re: report called from form is taking long time to print [message #412734 is a reply to message #412714] Fri, 10 July 2009 23:19 Go to previous messageGo to next message
shaz
Messages: 182
Registered: June 2009
Senior Member
Quote:
the procedure which calls report is having code which checks for default printer and does some validation to find the printer,server,location etc.


Your question itself has the answer.
Re: report called from form is taking long time to print [message #412785 is a reply to message #412734] Sat, 11 July 2009 16:02 Go to previous messageGo to next message
nastyjillu
Messages: 211
Registered: February 2009
Senior Member
yes. but it development server it takes 3 minutes to print the report.

in test server the same report is taking 10 minutes.

in production server the same report is taking less than a minute.

why is this difference???

is it due to server?? is test server slow than production server???

is it possible ?

thanks
jillu
Re: report called from form is taking long time to print [message #412787 is a reply to message #412785] Sat, 11 July 2009 16:55 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Development server <> Test server <> Production server.
Re: report called from form is taking long time to print [message #412825 is a reply to message #412787] Sun, 12 July 2009 12:05 Go to previous messageGo to next message
nastyjillu
Messages: 211
Registered: February 2009
Senior Member
are you saying that 3 servers are different , thats why its taking time ??

but does it take so much of time in test?? what makes it slow??

Re: report called from form is taking long time to print [message #412836 is a reply to message #412825] Mon, 13 July 2009 00:37 Go to previous message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Ask your system administrator, as well as DBA, how these servers differ. I guess that test server has less processor power, less memory etc. than the production one.
Previous Topic: Control Arrow Keys
Next Topic: ORA-12514: TNS: Listner does not currently know of service requested in connector descriptor
Goto Forum:
  


Current Time: Fri Sep 20 10:48:13 CDT 2024