Slowness Printing Customer Statements
Slowness Printing Customer Statements
(OP)
At one site, since updating from microfocus to the Fujitsu cobol versions of Macola, the AR Statement printing slowed down dramatically. Wondering if anyone else has experienced the same issue ? We did check indexs, and run SQL traces, and did notice the same issue running Statements in Macola Electronics, but there are not enought customers to notice the issue in Electronis, but it does exhibit the same issue. We have 76,000 customer records. If you print customer AAA, it takes 5-10 minutes before it will print, but if you print ZZZ it prints right away. The SQL trace revealed that after AAA prints, the program continues to read thru every single customer to the end of the file. When you print ZZZ there are no more customer, and bang you have your Statement.
Just looking for Feedback.
Thanks
Just looking for Feedback.
Thanks
RE: Slowness Printing Customer Statements
I have a customer database on my laptop with 11,000+ customers in the aropnfil_sql, and I am experiencing the same thing on 7.7.600.
You could use a crystal statement, which will be much faster.
Macola statements also update the aging buckets in the arcusfil_sql table, which is likely eating up a lot of time. How much data is in the aropnfil_sql in terms of purging AR open item records? I'll bet if you were aggressive with the purge it would help too.
None of this explains why it is taking longer with the new version. What has Exact said on this issue?
Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:
www.gainfocus.biz/exceladdin.html
RE: Slowness Printing Customer Statements
Don, do your comments (arcusfil & aropnfil) apply to ES as well?
RE: Slowness Printing Customer Statements
RE: Slowness Printing Customer Statements