Server Performance Question
I've been doing some testing with a certain report. The report uses a
somewhat complicated query that takes 0.8 seconds to execute (2.8 Ghz
P4) but only returns about 4 records. The report only takes one page,
but takes about 2.3 seconds to print in a thin client and a similar
amount of time in WebTier. Is this about the amount of overhead I
should expect from RR Server, or should I be able to speed this up?
somewhat complicated query that takes 0.8 seconds to execute (2.8 Ghz
P4) but only returns about 4 records. The report only takes one page,
but takes about 2.3 seconds to print in a thin client and a similar
amount of time in WebTier. Is this about the amount of overhead I
should expect from RR Server, or should I be able to speed this up?
This discussion has been closed.
Comments
That seems like a lot of time for a one page report--but I don't know what's
on that one page. I would profile the application to see where the
bottlenecks are.
Just my 2c
Ed Dressel
Team DM
what's
bottlenecks are.
That's what we thought. It is a simple report with 4 columns, and a small
logo in the top right, and another on the bottom footer. The images are 56K
and 86K in size, respectfully. They are bmp files. I wonder if using
another format would speed things up ?
Terry.
56K
Do you have the ability to profile the report? www.AutomatedQA.com is an
excellent tool for doing so.
Ed Dressel
We have a copy of SleuthQA Suite but we were behind in the upgrades before
TP went south. D7 might not be supported in the version we have. Nathan is
back tomorrow so he can try it then. He will also try converting the bmp's
to jpeg's to see how that affects things.
Terry.
A bit more on our performance problem, the system's CPU is being pegged at
100% for the duration it takes to run a single report.
Terry.
That still tells me nothing. Try downloading AQTime from AutomatedQA--theres
a demo for 30 days or something like that--and profile your application.
If you can create a encapsulated demo (i.e. does not require 3rd party
products, requires a minimum number of units) send me a copy and I will see
if I can find the bottle necks.
Ed Dressel
Team DM
what's
Thanks for the suggestion. I found a couple issues that were slowing things
down. For the record, here they were:
- I access the data view's SQL in code to do some last-minute modifications
and to log it. Accessing TdaQueryDataView.SQL.SQLText was slow, because it
triggered a call to CreateFieldsFromSQL. I was able to use the MagicSQLText
property instead.
- I dynamically set the captions of some labels in code. This was slow for
autosize labels because it was causing them to resize. I stopped using
autosize labels in these spots.