Performance problem - Conditional Formatting on Table

I am having a preformance problem which I seam to have narrowed down to the
conditional formatting I have placed on a table in my report :
I have some custom code which declares variables for all the formatting
fields. The values are taken from a database and are populated by a call to a
function in the custom code. The function is called by a dummy table placed
at the top of the report that references a stored procedure which returns one
row with all the formatting values. The formatting properties on the report
then reference the variables defined in the custom code.
The main body of the report is made up of a list component that contains
some charts and a table. With the data I am testing it on this list component
gets repeated 75 times when the report is rendered.
The conditional formatting is present on the charts and the table.
Without the conditional formatting on the table the report runs in under 10
seconds. If I add the conditional formatting to the table the report takes
nearly 3 minutes to run.
The table produces about 10 rows on average.
Conditional formatting on the charts does not cause any noticeable
performance hit.
Althought there is a lot of conditional formatting on the table (all color,
background ,border and font properties) I would not have expected it to have
such a dramatic affect on the preformance.
The report is being rendered to HTML.
Any ides why this is causing such a performance hit ?
Is it particular formatting properties that are causing the hit ?
Or a work around ?I wouldn'be surprised if the function which access the database for the
formatting parameters is being called for each row of the report..
To make sure what is happening regarding this, run SQL Profiler and monitor
while you run the report...
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Woodgnome" wrote:
> I am having a preformance problem which I seam to have narrowed down to the
> conditional formatting I have placed on a table in my report :
> I have some custom code which declares variables for all the formatting
> fields. The values are taken from a database and are populated by a call to a
> function in the custom code. The function is called by a dummy table placed
> at the top of the report that references a stored procedure which returns one
> row with all the formatting values. The formatting properties on the report
> then reference the variables defined in the custom code.
> The main body of the report is made up of a list component that contains
> some charts and a table. With the data I am testing it on this list component
> gets repeated 75 times when the report is rendered.
> The conditional formatting is present on the charts and the table.
> Without the conditional formatting on the table the report runs in under 10
> seconds. If I add the conditional formatting to the table the report takes
> nearly 3 minutes to run.
> The table produces about 10 rows on average.
> Conditional formatting on the charts does not cause any noticeable
> performance hit.
> Althought there is a lot of conditional formatting on the table (all color,
> background ,border and font properties) I would not have expected it to have
> such a dramatic affect on the preformance.
> The report is being rendered to HTML.
> Any ides why this is causing such a performance hit ?
> Is it particular formatting properties that are causing the hit ?
> Or a work around ?
>
>
>
>
>
>