WebTier Performance Issues?

rbuser

Hello,

Has anyone encountered severe performance issues using the webtier? I have a
simple 2 page report that generates quickly when I preview it locally, but
as soon as I request it from the webtier it can take around 2 minutes to
return (This is only accessing 2 records mind you). If I get into my bigger
reports (40 pages or so), forget about it. I am becoming very frustrated. I
am running my webtier on IIS 5, Windows 2000 Server, one 2 Ghz Xeon
processor, and 1Gig RAM. My database and my report server are on another
identical machine. Argh!

Another thing I have noticed is that the server that my webtier application
is on installed hits 100% cpu usage during the entire time the report is
being generated.

More Information:

1 - I am requesting the reports through SSL
2 - I automatically use Content=pdf instead of Content=viewer in my URL - Is
this bad?
3 - All applications where compiled with the most current components

If you need any other information, please feel free to ask.

Thank you,

Tracy McClarnon

nardmoseley

RB Server Edition is highly optimized and in our testing here and the
feedback from customers the performance is amazing. (as indicated by the
history of threads on this newsgroup).

As test, try accessing our live demo report server at
http://www.digital-metaphors.com/RBServerLive (note: it is running on port
81, so if you are behind firewall you need access to port 81.)

Try some icremental tests using our demos and then using your own reports.
Use the standard Content=Viewer for all of the test. Then perform another
set of tests with PDF. PDF will be a bit slower because the entire report
must be generated whereas the XHTML can be generated incrementally as the
user request pages via the viewer's nav buttons.

1. Test the reports using a standad ReportBuilder application.

2. Test the reports using a local server application and a client report
application that both run on the same machine.

3. Test the reports using a local server application and a webtier
application and a web browser that all run on the same machine.

4. Test the reports using a remote server and a client report application.

5. Test the report using a server and webtier application on one machine and
web browser on another machine.

Use Archives for long reports and use FileBased templates for others. These
will provide the best performance.



--
Nard Moseley
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Hi Tracy,

In my testing I have successfully used the webtier to produce 2000+ pages in
under a minute (not just lists, quite complex reports with graphics and
calculations), PDF output of the same took about 3 mins, on short reports it
is too quick to time! The only real difference I can see between my tests
and yours is that I have never tried it with an SSL connection, my test
server is a lower spec than yours however (Windows 2000 Server, Dual PIII
1GHz, 1Gb RAM, SQL Server 2000). The recent changes to the page caching made
in 7.02 has given me unparalleled performance in tests, far faster than a
Crystal Reports server running similar reports.

I couldn't suggest what the problem may be your having but I suspect there
must be some sort of configuration issue affecting your reports performance.

Best Regards

Simon Callcott

rbuser

Simon,

Thank you for the response. I have a few questions for you concerning your
setup:

1 - Does your WebTier and Report Server reside on the same machine?
2 - What type of application accesses your WebTier? Or does your WebTier
reside inside of your ISAPI application?

I have 3 applications - 1 Report Server (Running as a service), 1 WebTier
(ISAPI), and 1 IntraWeb ISAPI application that requests the report via a
URL.

Thank you,

Tracy McClarnon

rbuser

Tracy,

1 - Yes.
2 - For testing I have mainly been using the web tier report explorer. I am
using a Report Server running as a service and an ISAPI web tier. Our
application is not web based but a client server windows application.

Regards

Simon