Jump to content

BO orders page loading very slow


Recommended Posts

Suddenly the orderspage in the backoffice is loading very slow  (PS 1.6.09).

It takes over 20 seconds to load this.

Also searching in orders is very slow.

 

Everything else working normal. Also the frontoffice store is working normal.

I tried the database cleaner without succes.

 

Anyone has an idea what i can do?

Link to comment
Share on other sites

  • 1 month later...
  • 2 weeks later...
  • 1 year later...
  • 2 years later...

Hello,

I have the same issue here and I tried all the solutions as described above.

I removed all the hooks on: 

  • displayAdminOrder
  • displayBackOfficeHeader

Installation Details:

- Prestashop: 1.7.5.1

- PHP 7.1

- Orders Count: 17547 records.

 

Please, can you help me with this?

Thanks

 

 

Link to comment
Share on other sites

1 hour ago, José Ayram said:

Hello,

I have the same issue here and I tried all the solutions as described above.

I removed all the hooks on: 

  • displayAdminOrder
  • displayBackOfficeHeader

Installation Details:

- Prestashop: 1.7.5.1

- PHP 7.1

- Orders Count: 17547 records.

 

Please, can you help me with this?

Thanks

 

 

I analyzed the SQL Query for orders and I got a relationship with a custom table created by another developer. I created the missing index and works.

Thanks.

Link to comment
Share on other sites

  • 2 weeks later...
On 4/26/2019 at 7:39 PM, José Ayram said:

I analyzed the SQL Query for orders and I got a relationship with a custom table created by another developer. I created the missing index and works.

Thanks.

How do u resolved? Could u explain?

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...