Slow Oracle PDF driver with images.
Hello
A client of mine uses a bespoke piece of software, based on Oracle 10g, which generates output using Oracle Forms rwservlet.
The 10g PDFs are generated seemingly very slowly (perhaps 15 secs per B&W JPG), and here's what I've deduced.
The Java oracle forms is the front end for the application. In one particular form, a user can select to retrieve a number of drawings from the database, which is then compiled into a report by rwservlet and displayed on a users' client machine in Adobe Reader.
The only problem is, the processing is slower than the previous method which was with Oracle 9i Runtime sofware. The drawings retrieved from 9i were much faster, despite the actual drawing files remaining the same. They weren't generated via a PDF reader, but launched instead in a preview window. The old server hosting 9i is of a much lower spec than the 10g server, too, so it's a bit of a mystery.
I tried experimenting with the 10g PDFCOMP setting for rwservlet to affect how much compression was done. When I used the PDFCOMP=0 to generate the report, it seemed to generate faster PDFs, although the filesize remained almost identical (presumably it was trying to pointlessly apply lossless compression on JPEGs)
Does anyone know why this process is so slow on a dual processor 3GHz machine? When generating the reports, the CPU load according to task manager won't ever go about about 60% , and drops back to 50% or so after it's generated... is it possible the PDF generation process is being throttled/capped somewhere? Or is it just that the Oracle PDF driver is terrible??
Any thoughts welcome.
(I thought the way around it would be to generate the PDF once, save that in a BLOB and then retrieve the PDF BLOB every time the user hits print. Although I'm not sure what the developers would think about that....)
A client of mine uses a bespoke piece of software, based on Oracle 10g, which generates output using Oracle Forms rwservlet.
The 10g PDFs are generated seemingly very slowly (perhaps 15 secs per B&W JPG), and here's what I've deduced.
The Java oracle forms is the front end for the application. In one particular form, a user can select to retrieve a number of drawings from the database, which is then compiled into a report by rwservlet and displayed on a users' client machine in Adobe Reader.
The only problem is, the processing is slower than the previous method which was with Oracle 9i Runtime sofware. The drawings retrieved from 9i were much faster, despite the actual drawing files remaining the same. They weren't generated via a PDF reader, but launched instead in a preview window. The old server hosting 9i is of a much lower spec than the 10g server, too, so it's a bit of a mystery.
I tried experimenting with the 10g PDFCOMP setting for rwservlet to affect how much compression was done. When I used the PDFCOMP=0 to generate the report, it seemed to generate faster PDFs, although the filesize remained almost identical (presumably it was trying to pointlessly apply lossless compression on JPEGs)
Does anyone know why this process is so slow on a dual processor 3GHz machine? When generating the reports, the CPU load according to task manager won't ever go about about 60% , and drops back to 50% or so after it's generated... is it possible the PDF generation process is being throttled/capped somewhere? Or is it just that the Oracle PDF driver is terrible??
Any thoughts welcome.
(I thought the way around it would be to generate the PDF once, save that in a BLOB and then retrieve the PDF BLOB every time the user hits print. Although I'm not sure what the developers would think about that....)
ASKER
I see.
Presumably this cache will be bypassed as the documents always have printed date and time on, hence it's always regenerated.
Why is it so slow compared to the old 9i system though?
Presumably this cache will be bypassed as the documents always have printed date and time on, hence it's always regenerated.
Why is it so slow compared to the old 9i system though?
There is a parameter that says what is the retention interval.
It uses date/time of report creation, not the content of the report.
About how fast it is. If you use Unix I think it will be slow.
Unix/Linix are not intended to produce GUIs at all.
It is a disaster if you additionally need non English letters.
As I say the winning combination is Windows 2000 and Standalone Reports server.
It uses date/time of report creation, not the content of the report.
About how fast it is. If you use Unix I think it will be slow.
Unix/Linix are not intended to produce GUIs at all.
It is a disaster if you additionally need non English letters.
As I say the winning combination is Windows 2000 and Standalone Reports server.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I am satisfied by PDF Oracle driver.
There are many versions - OAS10g, Standalone Reports server.
I prefer installation of Standalone Forms/Reports Server on WINDOWS 2000 (this is the key advise!).
Oracle PDF driver on Unix/Linux doesn't work good for me.