Reports are soo slooooowww
-
Is this, perhaps, something we have configured wrong, but when we are requesting reports they are taking up to 10-15 minutes a time before they appear on the browser. We are not talking about complex reports, but one that simply extracts a line of data from 3 related tables and prints out a letter.
We have the data optimised and we have been using another we reporting tool to produce these letters and they are almost instantaneous.
The database and web servers are high spec machines (the web service having just been pulled out of the production environment to help with testing). Anti-viruses are disabled, nothing extra and redundant running, on windows Advanced Server 2000 with plenty of resources.
So why are reports taking so long.
I asked for a letter 10 minutes before starting to write this, and it has now only just appeared with the 'Report is being Generated' icon, and no report as yet.
Has anyone else experieced this. We are getting disconcerted as we have been very impressed with the design and what it can deliver and will suit us admirably, but the delay in report rendering is completely unacceptable in a commercial environment.
---------------------------------------
It is by caffeine alone I set my mind in motion.
It is by the Beans of Java that thoughts acquire speed,
the hands acquire shaking, the shaking becomes a warning.
It is by caffeine alone I set my mind in motion. -
Being a .Net app it compiles the first time you run and should get faster. I have just started working with RS and have not seen this issue and I am running everything on my laptop (2 ghz, 512 RAM), except for the data source. I'd be interested to see the SQL to get the data.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question -
We agree, we wou7ld have anticipated a slow start as everything compiled and then an increase in speed, but that isn't happening.
The hardware spec of the server are:
IIS - Dual PIII 667 with 1Gb RAM, 18Gb drive space, running ASP.NET & ColdfusionMX
SQL - Dual PII 450 with 1Gb RAM, 54Gb drive space dedicated to SQL 2000
This is our development system so there are no more than 6 users at a time.
The report is a basic letter which we usually deliver via Crystal Reports and appears in the browser in around 1-2 seconds.
We used the same query when designing the report for the Reporting Services and deployed the report. We anticipated an initial lag, but what we are getting is the report taking around 15-20 minutes to appear everytime it is requested.
We've monitored SQL and data delivery is as fast as ever, queries are optimised. We've monitored the IIS server and it is hardly showing any signs of life!! We migrated everything to a server with the same spec as the production server (twin Xeon) and still get the same results. The reports are being delivered over the same backbone as before, and if we stop the SQL Reporting Services and restart the Crystal Services, everything returns to full speed?!?!?!
The data query for extracting a single delegat address is as follows:
SELECT delegate.title, delegate.init, delegate.lname, employer.name,
EmpAddress.place AS EPlace, EmpAddress.street AS EStreet,
EmpAddress.town AS ETown, EmpAddress.city AS ECity,
EmpAddress.county AS ECounty,
EmpAddress.postcode AS EPostcode
FROM delegate INNER JOIN employer ON delegate.empidcode =
employer.empidcode INNER JOIN
address EmpAddress ON employer.addresscode =
EmpAddress.addresscode
WHERE (delegate.delegateid = @delegateid)
---------------------------------------
It is by caffeine alone I set my mind in motion.
It is by the Beans of Java that thoughts acquire speed,
the hands acquire shaking, the shaking becomes a warning.
It is by caffeine alone I set my mind in motion. -
I have noticed that going into Reports Manager, it is slow sometimes. But reports are running quickly. I see that you are using a parameter in the DS query. I too have just installed SRS. Let me try creating a report with a param and see. How are you accessing the report? Through Reports Manager or URL? If through URL, what are you rendering it as?
-
ARGGGGGGGGGHHHHHHH!!!!!
You are NOT going to believe this, but as a last straw we uninstalled the SQL Reporting Services for a fifth time and reinstalled it. Same prompts, same options, same selections.
What on earth happened I have no idea, but the reports manager is now running and the reports are deploying and rendering like the proverbial brown stuff sliding off a digging implement!
I just hope we don't have this rigmarole when we go live - but I have to confess, it leaves it's rival standing!
Many thanks for the assistance
---------------------------------------
It is by caffeine alone I set my mind in motion.
It is by the Beans of Java that thoughts acquire speed,
the hands acquire shaking, the shaking becomes a warning.
It is by caffeine alone I set my mind in motion. -
Good luck Rayven. Just curious, you are printing a letter. What do you think your end users will think about printing (export to PDF) this letter from SRS rather than from a Crystal report?
-
We've been investigating this. We can still supply them with a link that will call up a specific letter based on criteria they specify (bookind number, order number, etc). They were dubious at first that in order to print they have to export to a PDF, but once they realised that they frequently get asked over the phone for a copy of the letters and invoices and they currently either lose all formatting to email it, or else have to post it, the extra 2 clicks are bearable. Once we showed the scheduling of reports (one of ours takes half an hour to produce and just as long to print - it's a very detailed analysis) and they realised they could subscribe to reports, call up a report manager for fast access instead of trying to remember where in the system the link to the letter was, etc., they consider it a minor obstacle.
It would be nice to have a one-click print, or at least to have the PDF open automatically bypassing the Open/Save dialog.
However, everyone in the company has gotten fed up of Crystal crashing, caching report data when it shouldn't, etc., that they are all crying out for a replacement - and this looks like it will fit the jhob nicely.
---------------------------------------
It is by caffeine alone I set my mind in motion.
It is by the Beans of Java that thoughts acquire speed,
the hands acquire shaking, the shaking becomes a warning.
It is by caffeine alone I set my mind in motion. -
I wish you luck on your project. We are facing the same things here. Crystal is great, but we have too many crashes running in a web environment. SRS is my answer, but the printing is right now the speed bump.
-
Quite frankly, I don't think they are going to be given the choice. We can't afford the downtime that Crystal has been giving us, and the environment here changes that rapidly, most of the users are resigned to the fact that they have to change the way they work every now and then in order to reap the benefits elsewhere.
---------------------------------------
It is by caffeine alone I set my mind in motion.
It is by the Beans of Java that thoughts acquire speed,
the hands acquire shaking, the shaking becomes a warning.
It is by caffeine alone I set my mind in motion. -
Remember that you are supposed to be able hook into RS from existing or new APPS and immediately render in PDF or other formats. This may be the answer to the extra clicks.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question -
We've tried this, in fact have adopted it. I presume that you are referring to the rs:Format=PDF URL command.
If we link directly ro a PDF document then Acrobat reader is automatically summoned within the browser and the document opened. But when we use RS to do the same, we are prompted for a Save/Open first.
---------------------------------------
It is by caffeine alone I set my mind in motion.
It is by the Beans of Java that thoughts acquire speed,
the hands acquire shaking, the shaking becomes a warning.
It is by caffeine alone I set my mind in motion. -
Okay, I have a question then. I have used the URL access and Acrobat is not being summoned within the browser. It is being open in its own application window. Yesterday while testing, it was. What gives? I agree that if Acrobat opened within the broswer that life would be better. Please share what I'm missing....
-
Just spotted something.
There I was, happily pulling my hair out trying to get a report NOT to flow over 3 pages wide, happily clicking on the 'OPEN' button to view the PDF when suddenly one opened on it's own.
The difference? I had Acrobat open in the background this time, I had just closed the document, not the reader.
---------------------------------------
It is by caffeine alone I set my mind in motion.
It is by the Beans of Java that thoughts acquire speed,
the hands acquire shaking, the shaking becomes a warning.
It is by caffeine alone I set my mind in motion. -
Bingo!!! That is what I saw too. Here is the deal though. According to Adobe tech documents, PDFs are suppose to be able to open within a browser (http://www.adobe.com/support/techdocs/98fe.htm). However, I have been VERY unsuccessful with getting this to work. I have uninstalled Reader, installed the latest version, and I be darned if it doesn't work. I look in IE View Objects, and the Reader object doesn't show up.
Do you have any ideas? If we could just get this to work, I would be fine. I'm almost sick of looking at it
-
Nope, no solution yet
I suspect it's something to do with the way the reporting services deliver the PDF! If I create a page with a hyperlink or a javascript link to a PDF, the all open in the browser, no prompts, nothing!
As SRS to export as a PDF and there is the OPEN/SAVE box again.
Have to admit that I'm at a loss, but if I come across a resolution, you'll be the first to know.
---------------------------------------
It is by caffeine alone I set my mind in motion.
It is by the Beans of Java that thoughts acquire speed,
the hands acquire shaking, the shaking becomes a warning.
It is by caffeine alone I set my mind in motion.
Viewing 15 posts - 1 through 15 (of 16 total)
You must be logged in to reply to this topic. Login to reply