Home Server
New Blog Posts: Merging Reports - Part 1 and Part 2

Server Performance Question

edited November 2003 in Server
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?

Comments

  • edited November 2003
    > I've been doing some testing with a certain report. The report uses a

    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
  • edited November 2003
    > That seems like a lot of time for a one page report--but I don't know
    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.
  • edited November 2003

    56K

    Do you have the ability to profile the report? www.AutomatedQA.com is an
    excellent tool for doing so.

    Ed Dressel
  • edited November 2003
    > Do you have the ability to profile the report? www.AutomatedQA.com is an

    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.
  • edited November 2003
    > Do you have the ability to profile the report? www.AutomatedQA.com is an

    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.
  • edited November 2003
    >

    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
  • edited November 2003
    > That seems like a lot of time for a one page report--but I don't know
    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.
This discussion has been closed.