Serious performance issue. Large wp_packlink_entity table slowing everything down...

[maartenhunink]

At the moment adding a product to the cart takes 20 seconds. While researching why, I discovered it's caused by the Packlink plugin, and seems to happen due to the large wp_packlink_entity table.

If I disable the plugin or empty the table, adding an item to the cart takes less then a second.

We currently have 1680 orders, and the wp_packlink_entity table has 20597 entries. The majority are of the type 'ShippingMethodMap', 'QueueItem' and 'Process'.

When I remove them, the site speed increases dramatically. Is is safe to remove old items? Can they be removed automatically so the website continues to be fast? Or can the database queries be optimised so the speed is not effected as much by this table?

For reference: when checking New Relic, the packlink plugin is the most time consuming on the site.

If it's helpful to share a sql file of the table, I'm happy to do so.

[germanoronoz]

Hello,

We are having this exact same issue, and reported repeatedly to support team at Auctane, but they do not escalate our requests to the development team as we do not have FTP / CPANEL or similar server access (we are on AWS).

The CPU of the database instances were maxed out. Due to being hosted on AWS, we pay per use, so this is costing us money. We have tried completely uninstalling the plugin, deleting the database table and saved options so it was a fresh Packlink install, and starting the configuration from scratch.

Like @maartenhunink says on his post, when cleaning the table, the performance goes back to normal, but with some time the problems remain the same.

This is what happens:

• We activate the plugin
• It creates the wp_packlink_entity table in the database
• It fails to load the carriers properly
• It starts adding in that table thousands of lines (before uninstalling, our sites had each 100'000+ rows each)

The plugin constantly makes db queries to get all the rows (with no limit) from that wp_packlink_entity table.

If the table had a few tens of rows there would be no problem, but there are literally thousands, and it keeps adding more and more.

There are several 1 star reviews on the official wordpress repository, some of them talk about this issue:
https://wordpress.org/support/plugin/packlink-pro-shipping/reviews/?filter=1

For example this one is talking about the exact same issue:
https://wordpress.org/support/topic/poorly-optimized-2/

We already tried the asynchronous shipping methods loading option, but it does not help.

We deploy new code from a staging environment using AWS CodeDeploy, and no live code changes can be made on production because there are many instances and a load balancer, so as said, there is no FTP, Cpanel or similar access.

For now, we had no choice but uninstalling temporarily the plugin where we had it active. We informed our customers that you are looking into it and when it is really solved we will reactivate it on all sites, but it has been months and the problems remain the same.

Hope you can find a solution for the issue soon.

Best regards!!