Report Spooling slow

[Guest]

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.