I have a client who has many, many valid coupon codes in his events_groupon_codes tables, over 19,0000 in fact.
The way the groupons_admin_page.php file has been written the entire table is used to generate the admin page. This causes many minutes of wait time before the page is rendered and available for use. This is causing my client some issues as he often has clients on the phone when admin needs to be performed on these codes.
Is there anyway to avoid the full table load each time? I’m no php guru but I have some experience and can plod through some code amendments if pointed in the right direction.
As an aside I think the query on line 212 would be more performant written like this:
$wpdb->get_results(“SELECT * FROM ” . EVENTS_GROUPON_CODES_TABLE . “LIMIT 1”);
Apologies for posting this in the wrong forum but my clients site was formerly administered by another developer so I do not have the required login details associated with the license key. Maybe a moderator can move this to the correct area?
It is best if you can log into the the licence holders account to request support assistance, as proof of a valid support licence is required.
However, I will advise that in order to change the groupon plugin to do what you are asking would require more than just the code snippets we supply in support, it is a customisation.
We do offer customisation services, and also have recommended developers if we do not have capacity for the job.
The support post ‘Groupon admin page takes many minutes to load….’ is closed to new replies.
Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.
Considering Event Espresso for a new project? Tell us more through our contact page.