×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Slowness Printing Customer Statements

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

RE: Slowness Printing Customer Statements

Wow thats a lot of statements. What version are they on now? What options are they selecting on the criteria to run the 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

I am actually seeing something very similar on my ES 9.5.300.  Printing statements takes hours.  I believe that there are other issues impacting the indexes on customer tables.  I have not yet spent time doing traces etc.
Don, do your comments (arcusfil & aropnfil) apply to ES as well?

RE: Slowness Printing Customer Statements

(OP)
ES tables would be GBKMUT and BankTransaction.  Which version and service pack of SQL are you on?

RE: Slowness Printing Customer Statements

Last spring we upgraded to SQL 2005 (Version 9.00.5057.00) that is SP 4 with a few updates.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close