×
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

Macola ES Speed Issues

Macola ES Speed Issues

Macola ES Speed Issues

(OP)
thread639-1495390: ES 9.5 Users I need some help


Peter Shirley wrote:
Agree with you on the aging reports.  If customers and resellers can produce versions that run quickly and accurately, Exact should be able to as well..The nature of the tables (gbkmut, banktransctions etc.) accentuate performance problems in SQL and there are a number of things you can configure on your SQL server that will offset the problems caused by long running queries.They are too lengthy to go into here, but I'd be happy to forward you some suggestions.  Peter ShirleyMacola Consultant, PA and surrounding states.

--I'm interested in what we can configure in SQL.  

RE: Macola ES Speed Issues

Hopefully Peter will chime in.  But what version and edition of SQL are you running?  How big is your database?  The version/edition of SQL can make a huge difference in performance.

I will say that, regardless of version/edition issues, Peter's aging reports run in seconds whereas Exact's take minutes or hours.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports.  Check out our Macola tools:
www.gainfocus.biz/exceladdin.html

RE: Macola ES Speed Issues

(OP)
SQL Server 2005 Standard Edition
Database size: 98.5 GB

Our aging reports definitley take a bit to run out of ES. But one of our biggest issue comes from Lock ups between Cash Flow, G/L , AP , Production etc. It seems if any one is running excel add in for financials or doing AP postings and such we start experiencing slow downs and lock ups
  

RE: Macola ES Speed Issues

That is one big database - the biggest I have heard of yet for ES.  But then a lot of my larger Progression customers have not made the move to ES.

Peter's aging reports should definitely help you.

Please define "lock up".  Are you actually getting an error message or are you deciding to kill a process because it is taking too long?

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports.  Check out our Macola tools:
www.gainfocus.biz/exceladdin.html

RE: Macola ES Speed Issues

(OP)
We get error messages,our applications freeze, or just take a lot longer to go through.  

Mariestel Salas  

RE: Macola ES Speed Issues

Experiencing extremely slow performance with commissions due report compared to progression. Anyone have a suggestion or alternative to running the native report?

ES v9.5.3

RE: Macola ES Speed Issues

In terms of the agings, the reports don't take two long.  It is the process that creates a copy of the gmkmut and banktransaction file that is a killer.  

RE: Macola ES Speed Issues

MSC814 - sorry for the slow response; it's been a while since I stopped in here.

I have a document I would be happy to share with you if you drop me an email via the website in my signature.

Peter Shirley
Macola Consultant, PA and surrounding states.
http://www.erpessentials.com

RE: Macola ES Speed Issues

A/R - Customers - Maintain - Statistics (Slow)

Macola ES 9.5.400 - Recently Upgraded

After upgrade we noticed a significant degradation in performance on loading the Statistics tab from A/R - Customers - Maintain. Has anyone else encountered this and have any solutions?
Our performance has gone from a few seconds to 1 hour + to run.

I have done some research and found:
Attempted to run a trace with SQL Profiler and found a statement that would be running and max out the CPU.

Attempted to "breakdown" the statement to individual pieces:
- Sales of goods - data was returned
- Cost of goods - remained executing (ran for 1 hour 10 minutes)
- Invoice count - data was returned
- Paid count - data was returned

After comparing SQL statements between 9.5.200 and 9.5.400 there are LTRIM and RTRIM functions in the 9.5.400 version that appear to be extremely slowing the system down (These did not exist in the 9.5.200 version). In a test run in a new SQL Query I took the 9.5.400 SQL statement and removed the LTRIM and RTRIM function lines and data was returned quickly. There was 3 instances of the function line in the Cost of Goods section ---
OR LTRIM(RTRIM(d.debcode)) IN (Select LTRIM(RTRIM(debcode)) from cicmpy where InvoiceDebtor = (select debnr from cicmpy where debcode = '<ACCOUNT NUMBER HERE>' ))

Response from Exact:
The LTrim(RTRIM()) statements are in there for the differences between AlphaNumeric and Numeric alignments in the tables so they can't be changed or removed. We're not sure if we can adjust the query further to improve speed. If you would like us to attempt that we would need a copy of your data because currently there are not other sites reporting slow speed for the statistics tab.

I'm curious about other experiences and solutions.

Thank you.

RE: Macola ES Speed Issues

If the fields were index fields, I beleive performing a function on the fields would loose the value of an index.  Thus your performance would be degraded.  Great post on comparing what is going on.  

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