Support

Home Forums Event Espresso Premium Registration Checkout/Add-to-cart slow with multi-event reg (esp_line_item table

Registration Checkout/Add-to-cart slow with multi-event reg (esp_line_item table

Posted: June 17, 2020 at 4:16 pm


nicetouch

June 17, 2020 at 4:16 pm

It appears that there are many many queries going to the esp_line_item table during checkout and when adding events to cart. The major lag when adding to cart happens when there is at least one event in the cart and multiple events are added. For example, if zero events are in the cart and I add 25 events, the add-to-cart takes about 5 seconds. If one event is in the cart and I add 25 events, the add-to-cart takes 25 seconds. Seems like inefficient query logic? I’ve read about this in other posts here, but haven’t seen a solution. Anything I’m missing?


Tony

  • Support Staff

June 19, 2020 at 7:11 am

Hi there,

Can you provide more details on the test you are doing, please?

You can’t add multiple ‘events’ to the cart at once, you can add multiple tickets from each individual into the cart.

So I assume your add adding 25 tickets in the cart?

So add say 1 Ticket from Event A into the cart.
Then add 25 tickets from Event B into the cart?

For me, testing that takes ~1 second for both requests: https://monosnap.com/file/twSexmQnVLyTikD9TGH17eeIJA5P6x

The support post ‘Registration Checkout/Add-to-cart slow with multi-event reg (esp_line_item table’ 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.

Event Espresso