Smart coupon database update in progress for a long time

Hi @samisraeli ,

Greetings from WebToffee Support.

To better understand the issue you are experiencing, could you provide some additional details? Specifically, we need to know whether the issue occurred when you installed the plugin for the first time or when you tried to update the plugin to the latest version.

Additionally, it would be very helpful if you could share the WooCommerce System Status report. You can access this report by navigating to WooCommerce -> Status -> Get system status report. This report provides details about your site environment and configurations.

Once we have this information, we will be able to investigate the issue further and provide you with the appropriate assistance.

Thank you for your cooperation.

The issue occurred when I installed the plugin for the first time.

Hi @samisraeli ,

Thanks for providing us with the information. We have investigated the issue further and would like to share our findings with you.

The problem you experienced is a result of the large number of coupons on your site. Each coupon, along with its corresponding details, is stored as a post in the database. Furthermore, every order, product, post, page, and associated data is treated as a post, adding to the overall database load.

Navigating through the numerous posts and post meta to access coupon and coupon meta data can significantly slow down your site’s performance. In order to optimize plugin functionality and improve performance, we have introduced a lookup table mechanism. This table stores coupon and coupon meta data separately, reducing the need to navigate through individual posts and post meta.

During the installation process, the plugin initiates a migration of existing coupon data to this lookup table. Once this migration is completed, future issues related to site performance should be resolved.

We would appreciate it if you could provide us with an update on the current progress of the migration process and whether it has begun to proceed smoothly again. We understand the inconvenience this may have caused during the process, and we apologize for any disruption.

Looking forward to your response.

It finished the process after 3 hours.
What happen if I disable the plugin? Will I need to run a new migration?

Hi @samisraeli,

Thanks for sharing the update with us. If the migration process has been completed, there won’t be a need for a new migration when you deactivate and activate the plugin again.

However, if the process was not fully completed, once you deactivate and activate the plugin again, it will resume from where it was paused, not from the beginning.

If the process has been completed on your site, you shouldn’t encounter any issues upon deactivation and reactivation.

Let us know if you have any further questions or concerns.

Hi?@samisraeli ,

We haven’t heard back from you for a while. As this thread has been inactive for some time, we are marking it as resolved.

If?you?require any further assistance, please reach out to us using a new thread.