Report Spooling slow

[LisaConsult]

I have a fairly large access application. It is split FE/BE with the BE
residing on a Novell Network drive. I have implemented most of the
performance hints that are suggested and overall the app is/was running fine.
However, due to needing International currency symbols, I recently converted
from Arial to Arial Unicode MS on about 15 fields in an Access report.
Additionally, I have modified to these fields for formatting (e.g.formatting
used to say
=IIf([Sal1]=0,"",IIf([PayBasisSW]="S",Format([Sal1],"$#,##0.0"),Format([Sal1],"$#,##0.00")))
and now says
=Replace(IIf([Sal1]=0,"",IIf([PayBasisSW]="S",Format([Sal1],"$#,##0.0"),Format([Sal1],"$#,##0.00"))),"$",[txtSymbol])
where [txtSymbol] is a field on the report header which tells the currency
Symbol).

In printing this report across a network (database on network and printer on
network). The spooling used to be neglible. Now the spooling is taking up
to 10 minutes for 170 pages. The spooling is not as bad on an MS network,
but also still a bit slow. Is it the Unicode font or the formula that's
killing me? Any suggestions of ways to reduce the spool time? Thanks.

 

[Kevin]

Using Arial Unicode MS will increase the volume of data that is transferred
over network, and using the conditional formatting will increase the report
processing time. These factors can certainly be the probable cause of the
problem you're having. If you want to make sure, you can change the font
back to Arial and remove the format settings and see if the performance is
better.

You may also want to call Novell Network support for any suggestions on
tuning the performance.

 

[LisaConsult]

To clear Arial Unicode of any future suspicion. I have resolved this issue
and I found that it wasn't Arial Unicode at all. Rather in the formula,
[txtSymbol] was a field on the report in the report header. The
controlsource was set to a SQL query across the network to the app database.
I thought that since it was placed in the report header it would only run
once in the report. However it was actually running everytime I referenced
it. Killer! I changed it so that txtSymbol is assigned a value in the
Report_Activate event and everything runs much quicker.

Using Arial Unicode MS will increase the volume of data that is transferred
over network, and using the conditional formatting will increase the report
processing time. These factors can certainly be the probable cause of the
problem you're having. If you want to make sure, you can change the font
back to Arial and remove the format settings and see if the performance is
better.

You may also want to call Novell Network support for any suggestions on
tuning the performance.

I have a fairly large access application. It is split FE/BE with the BE
residing on a Novell Network drive. I have implemented most of the
performance hints that are suggested and overall the app is/was running
fine.
However, due to needing International currency symbols, I recently
converted
from Arial to Arial Unicode MS on about 15 fields in an Access report.
Additionally, I have modified to these fields for formatting
(e.g.formatting
used to say
=IIf([Sal1]=0,"",IIf([PayBasisSW]="S",Format([Sal1],"$#,##0.0"),Format([Sal1],"$#,##0.00")))
and now says
=Replace(IIf([Sal1]=0,"",IIf([PayBasisSW]="S",Format([Sal1],"$#,##0.0"),Format([Sal1],"$#,##0.00"))),"$",[txtSymbol])
where [txtSymbol] is a field on the report header which tells the currency
Symbol).

In printing this report across a network (database on network and printer
on
network). The spooling used to be neglible. Now the spooling is taking
up
to 10 minutes for 170 pages. The spooling is not as bad on an MS network,
but also still a bit slow. Is it the Unicode font or the formula that's
killing me? Any suggestions of ways to reduce the spool time? Thanks.

 

[Kevin]

Great!

I believe no one can find this cause without inspecting the report while
sitting in front of your computer. Anyway, congratulations on solving the
problem

To clear Arial Unicode of any future suspicion. I have resolved this
issue
and I found that it wasn't Arial Unicode at all. Rather in the formula,
[txtSymbol] was a field on the report in the report header. The
controlsource was set to a SQL query across the network to the app
database.
I thought that since it was placed in the report header it would only run
once in the report. However it was actually running everytime I
referenced
it. Killer! I changed it so that txtSymbol is assigned a value in the
Report_Activate event and everything runs much quicker.

Using Arial Unicode MS will increase the volume of data that is
transferred
over network, and using the conditional formatting will increase the
report
processing time. These factors can certainly be the probable cause of the
problem you're having. If you want to make sure, you can change the font
back to Arial and remove the format settings and see if the performance
is
better.

You may also want to call Novell Network support for any suggestions on
tuning the performance.

I have a fairly large access application. It is split FE/BE with the BE
residing on a Novell Network drive. I have implemented most of the
performance hints that are suggested and overall the app is/was running
fine.
However, due to needing International currency symbols, I recently
converted
from Arial to Arial Unicode MS on about 15 fields in an Access report.
Additionally, I have modified to these fields for formatting
(e.g.formatting
used to say
=IIf([Sal1]=0,"",IIf([PayBasisSW]="S",Format([Sal1],"$#,##0.0"),Format([Sal1],"$#,##0.00")))
and now says
=Replace(IIf([Sal1]=0,"",IIf([PayBasisSW]="S",Format([Sal1],"$#,##0.0"),Format([Sal1],"$#,##0.00"))),"$",[txtSymbol])
where [txtSymbol] is a field on the report header which tells the
currency
Symbol).

In printing this report across a network (database on network and
printer
on
network). The spooling used to be neglible. Now the spooling is
taking
up
to 10 minutes for 170 pages. The spooling is not as bad on an MS
network,
but also still a bit slow. Is it the Unicode font or the formula
that's
killing me? Any suggestions of ways to reduce the spool time? Thanks.