Hi Irfaan

The best advise I can give you at this stage is to seriously consider start purging old customer history.

Do this as follow:

1. Decide and agree on transactions older than which date should be purged

2. Backup the company and ensure all other users are logged out

3. Now go  to Customers | Maintenance | purge Transactions

4. Complete the screen as appropriate and start the purge. 

Note that no customers' balances will be affected in any way and that only FULLY allocated transactions are removed form the database.

Now try to open the Allocation screen and check if there are any speed performances

Kind Regards

Bennie 

Dear Bennie,

Thanks.

On a test database, I have purge all customer transactions older than 1st of Jan 2020. 

But the problem still persists.

I tried to open that same customer, "The Shop" and Evolution has frozen..

From SQL Profiler, I see the batch started/completed to retrieve "The Shop" data/query and yet Alloc screen does not appear. 

Dear Bennie,

Thanks.

On a test database, I have purge all customer transactions older than 1st of Jan 2020. 

But the problem still persists.

I tried to open that same customer, "The Shop" and Evolution has frozen..

From SQL Profiler, I see the batch started/completed to retrieve "The Shop" data/query and yet Alloc screen does not appear. 

Hi Irfaan

Please perform a Refresh Views routine by opening the link below.

If that doesn't work to improve the extreme slowness, please let me know.

https://za-kb.sage.com/portal/app/portlets/results/viewsolution.jsp?solutionid=200325121353245&page=1&position=1&q=REFRESH%20VIEWS%20ROUTINE%20-%20COMPANY%20DOWNGRADING%20AND%20UPGRADING

Hi Bennie,

I did the Refresh view routine, unfortunately it hasn't improved at all.

I have even purged data up to June 2020.

But there is hardly any noticeable improvements.

Hi Irfaan

In that case, let's escalate your query to become a official Evolution query.

Therefore, please do the following:

Open the link below and log your query on the Evolution Online Support platform, but request that your query be sent for my attention so I can then properly investigate and follow up with you. 

https://app.smartsheet.com/b/form/4c5023eeaff24b05839f55753b05c465

Kind Regards

Bennie 

Hi Bennie,

As per your suggestion, I have logged the case.

Thanks Irfaan

Yes, I received the new query and responded to you per e-mail today.

Kind Regards

Bennie