Help Desk

Event Tickets Plus slow query issues on wp-admin

  • Posts: 6 Topics: 1
    | Permalink

    We’ve been working with the Event Tickets Plus addon recently and have noticed that the wp-admin Events list view starts to really slow down to the point of timing out most of the time after creating tickets for each of the events in our system (close to 500 total events).

    This support thread: https://theeventscalendar.com/support/forums/topic/events-admin-page-loading-insanely-slow/ sounds like the same issue we’re experiencing yet we’re on version 4.6.2 of the Event Tickets Plus addon and this issues appears to have been fixed many versions ago. All of the plugins on our site are up to date. The issue persists when we test in a sandbox environment to determine if the issue was a theme/plugin conflict.

    The WordPress ‘Query Monitor’ plugin shows a huge difference in loading times depending on whether or not the Event Tickets Plus plugin is activated – see attached screenshots for details. Hiding the attendee column doesn’t appear to make a difference, the extra queries are still happening.

    Posts: 5756
    | Permalink

    Hi Gabriel,

    Thanks so much for reaching out!

    I’m sorry to hear that your site is running slowly with use of our plugins.

    As a first step, can you make sure that all of your Events Calendar related plugins are up-to-date?

    Also, please have a look at our Performance Considerations and see if there is anything you can adjust in order to help your site run better:

    https://theeventscalendar.com/knowledgebase/performance-considerations/

    After that, you may be interested in caching, so take a look at this article:  https://theeventscalendar.com/knowledgebase/caching-basics/

    In addition, you can check out some of the solutions provided in this forum post:

    https://theeventscalendar.com/support/forums/topic/decreasing-loading-time-for-big-amount-of-events/

    I would also recommend looking into some of the plugins in this blog post, as they may be able to help you pinpoint where site slowness may be occurring:

    https://theeventscalendar.com/favorite-developer-plugins/

    Let me know how it goes and if you need any further assistance on this topic!

     

    Thanks,

    Jaime

    Posts: 6 Topics: 1
    | Permalink

    Hi Jaime, all of our the plugins are up to date. I believe the issue is clearly explained in the screenshots attached to the original post. The problem is with the Tickets Plus action that checks order status on every index load. The issue I linked from last year was the same issue we’re experiencing now.

    Please help!

    Posts: 5756
    | Permalink

    Hi Gabriel,

    According to your system information, some of your plugins are not up-to-date.  Would you mind double-checking and re-sending your system information.

    Also, for now, you can try removing the attendee column, which indicates the percentage of tickets sold:

    add_filter( 'tribe_tickets_supported_admin_columns', '__return_empty_array' );

    Let me know if that helps!

     

    Thanks,

    Jaime

    Posts: 6 Topics: 1
    | Permalink

    Hi Jamie, this is frustrating because we’ve already spent hours troubleshooting the issue. The plugins that are out of date now were not out of date during our troubleshooting process are not affecting this issue.

    As stated in the initial post, removing the admin column doesn’t make a difference, the issue persists.

    Could you please look into this in more detail?

    Posts: 5756
    | Permalink

    Hi Gabriel,

    Could you provide me with your slow/duplicate queries from Query Monitor?

    Could you also share an export of your database? Most hosts provide a means of doing this and you could then upload it here in zip format as a private reply.

    Let me know if you have any other questions in the meantime!

     

    Thanks,

    Jaime

    Posts: 6 Topics: 1
    | Permalink

    Hi Jaime, I have a PDF for you that shows the query monitor results but the help desk won’t allow me to attached a PDF!

    Posts: 5756
    | Permalink

    Hi Gabriel,

    Can you possibly add the results to Dropbox or Google Drive and send in a private reply?

    Let me know!

     

    Thanks,

    Jaime

    Posts: 6 Topics: 1
    | Permalink
    This reply has been marked as private.
    Posts: 5756
    | Permalink

    Hi Gabriel,

    Thanks for providing me with that information.  Can you update your WordPress version and see if the issue still occurs?

    Also, if you temporarily turn off your SEO plugin, do you see better performance on your site?

    Let me know!

     

    Thanks,

    Jaime

    Posts: 6 Topics: 1
    | Permalink
    This reply has been marked as private.
    Posts: 5756
    | Permalink

    Hi Gabriel,

    Thanks for your feedback.  I am going to get some feedback from my colleagues on this issue, and I will report back to you when I have some more information.

    Thank you for your patience and understanding in this issue.

     

    Thanks,

    Jaime

    Posts: 5756
    | Permalink

    Hi Gabriel,

    I just wanted to update you and let you know that I have passed this information to our developers to take a look at.

    I have logged a ticket for this issue and you will be updated when a fix has been released.

    Thank you for your patience as we see this through.  Please let me know if you have any other questions in the meantime!

     

    Thanks,

    Jaime

    Posts: 6 Topics: 1
    | Permalink

    Thank you for the update!

    Posts: 5756
    | Permalink

    No problem, we’ll keep you posted!

    Posts: 5756
    | Permalink

    Hi Gabriel!

    Just wanted to share with you that a new release of our plugins is out, including a fix for this issue 🙂

    Find out more about this release —> https://theeventscalendar.com/maintenance-release-week-25-march-2018/

    Please update the plugins and let us know if the fix works for your site.

    Best,
    Jaime

    Posts: 7
    | Permalink

    Hey there! This thread has been pretty quiet for the last three weeks, so we’re going to go ahead and close it to avoid confusion with other topics. If you’re still looking for help with this, please do open a new thread, reference this one and we’d be more than happy to continue the conversation over there.

    Thanks so much!
    The Events Calendar Support Team

    | Permalink

The topic ‘Event Tickets Plus slow query issues on wp-admin’ is closed to new replies.