I'm experiencing the exact same issues. I've tried Prestashop versions 1.7 and 8.1, and I'm having the same problems with all versions except for 1.6, which I'm currently using.
Here's my situation:
I've been using Prestashop 1.6 for the last 10-12 years.
I've been trying to upgrade to the latest version for the past 2-3 years (yes, you read that right!).
So, what's preventing me from upgrading? Here are the issues:
- Slow pagination: After upgrading to any latest version like 1.7.x.x and 8.1.x.x, pagination becomes very slow. It loads slowly at random, sometimes working fine for the first 4-5 pages, then becoming very slow and taking 10-12 seconds to load every next page. The pages load instantly when I visit them again.
- Slow orders page loading: The orders page in the backend takes around 120 seconds to load. The same page takes just 4-5 seconds to load in Prestashop 1.6 (there are lots of orders).
- Overall slow backend performance: Compared to Prestashop 1.6, the overall backend performance feels slow.
I've tried the following:
- Uninstalled almost every module (including Faceted search).
- Used Memcached cache.
- Enabled/Disabled OpCache and Prestashop cache.
- Used different servers like Ubuntu, CentOS, Alma, Rocky, etc., with different configurations.
- Used different PHP versions from 7.4 to 8.2.
- Used different web servers like Apache and Nginx.
- Optimized the database.
- Re-built the search index and re-generated the images.
- Tried different themes.
- Hired some developers to fix the issues, but they couldn't understand the problem and blamed the large data. They said Prestashop 1.6 is very efficient in handling large data, but Prestashop completely restructured their code for later versions, which might be the problem. So I deleted all orders for testing, and it fixed the order page loading issue as expected (Deleting the orders is not a solution though). The pagination issue was not fixed even after deleting the orders.
My current staging server configuration:
- Server OS: AlmaLinux 9.4 (Seafoam Ocelot)
- CPU: AMD EPYC-Milan Processor (8 cores)
- RAM: 16.00 GB
- Web Server Software Version: Nginx 1.26.1.1-2
- PHP Version: 8.2.22
- Memory Limit: 4096M
- Max Execution Time: 600
- Max File Upload Size: 128M
- PrestaShop Version: 8.1.7
- Theme: Default Classic theme
- Control panel: Plesk Obsidian 18.0.63
I hope someone can help me resolve these issues.
Kind Regards