Support

Home Forums Event Espresso Premium Extremely slow speed processing an order

Extremely slow speed processing an order

Posted: September 5, 2017 at 6:12 am

Viewing 20 reply threads


Bosworthsgc

September 5, 2017 at 6:12 am

Hi

Having just put a customer order through for several events we have noticed that it has taken a very long time for each screen to move. Rest of the site seems ok
Can you suggest why this might be please
Thanks


Tony

  • Support Staff

September 5, 2017 at 8:21 am

Hi there,

There’s a lot of possible reasons, what type of hosting are you using?

If you go to Event Espresso -> Maintenance -> System Information.

Search for WP Memory and see what value is set for that.


Bosworthsgc

September 5, 2017 at 8:31 am

wp_memory 40M – We recommend setting memory to at least 64MB. See: Increasing memory allocated to PHP ”


Tony

  • Support Staff

September 5, 2017 at 8:35 am

That’s low and should be upped to at least 96MB, more if available.

What type of hosting are you using?

To increase the memory limit you can follow the steps here: https://codex.wordpress.org/Editing_wp-config.php#Increasing_memory_allocated_to_PHP

Basically add something like define( 'WP_MEMORY_LIMIT', '128M' ); to your wp-config.php file.


Bosworthsgc

September 5, 2017 at 8:37 am

ITs with 1 and 1.co.uk I beleive it is a shared server


Bosworthsgc

September 6, 2017 at 3:04 am

Hi Tony

I have added this line in to the wp-config.php file

(I downloaded, saved the original as .old just in case I need to refer back to it, then added the line above and re-saved, then overwrote the original file)

Is there a way to test it is taking note of the line and has actually increased the memory limit?

I know some hosts don’t allow it – not sure about 1and1.co.uk

Thanks


Tony

  • Support Staff

September 6, 2017 at 3:30 am

You can check in System info and search for both WP Memory and memory_limit to confirm if the value has been set.

However to actually test how much memory your site actually has (the value may be set but you may not have that amount available) you need to run a script on the site that test the memory. For example:

https://magazine.joomla.org/issues/issue-dec-2010/item/295-Are-you-getting-your-fair-share-of-PHP-memory

Or another way to test it is to use the Event Espresso requirements check plugin:

https://eventespresso.com/requirements/#compatibility

If you install that plugin and then go to Toosl -> Event Espresso requirements

There is a section that allows you to test your available memory there.

ITs with 1 and 1.co.uk I beleive it is a shared server

Shared hosting means the performance of your site depends on what every other site on that server is doing. If another site is hitting the database hard under heavy load, its going to slow your site down even if you have very little traffic at that time.


Bosworthsgc

September 7, 2017 at 2:42 am

Hi Tony

We have now changed our hosting package giving more php memory and I have also run various compression tools etc (using wpmudev tools)

The main website has now sped up but the booking side of things is still very slow.

Is it something to do with the grid set up that we are using. I dont really want to change this as visually it does exactly what we need but it is taking between 12 and over 20 seconds from pressing one of the dates for the ticket selector to load.

My concern is that people will get fed up of waiting and not book or they will call us to book.

IF you can offer any further solutions I would be most grateful

Thanks
Jonathan


Tony

  • Support Staff

September 7, 2017 at 3:23 am

It is not the grid system if it is after you have clicked through to view the event.

How many datetimes/tickets do you have on the event that is loading?

Can you link me to the grid where you see this happens so I can click through.


Bosworthsgc

September 7, 2017 at 3:40 am

Hi Tony

The snowglobe event and grotto are the worst

The slowdown occurs from this page https://bosworthsgc.co.uk/our-events

Then when you click on either Snowglobe or Grotto there is a delay and also then from when you click the date chosen

Thanks


Tony

  • Support Staff

September 7, 2017 at 5:00 am

Yeah it’s happening on the grid itself and is likely due to the amount of events loading on a single page and the amount of processing required to calculate the remaining spaces on each event.

Try editing the template you are using and editing out the code used to output the spaces available, does it load faster?


Bosworthsgc

September 7, 2017 at 7:32 am

Hi Tony

I have edited the template and removed the code that output the available spaces.

Unfortunately, it made no difference to the speed

Would there be anything else I can try please?

Thanks


Josh

  • Support Staff

September 11, 2017 at 11:32 am

It looks like you’re pulling in two different shortcodes on each page, to display two sets of events list. It will probably reduce the time by about 50% if you do one shortcode instead.

Along with the above, removing the code that displays the available spaces will not speed anything up if the code that queries for the number of available spaces is still in place. The difference in speed can only happen if the number of queries is reduced.


Bosworthsgc

September 12, 2017 at 2:08 am

Hi Josh

I did try to remove the code that displays the available spaces but it didnt speed things up

I am not sure where you mean about the two shortcodes. For example, if you go to the events and select Snowglobe it seems to be at this point that is at its slowest

Could you tell me where you mean that there are two shortcodes.

Thanks


Tony

  • Support Staff

September 12, 2017 at 2:35 am

I did try to remove the code that displays the available spaces but it didnt speed things up

Yes, but did you remove it all or just the code that actually outputs the text?

Your using the code from here: https://eventespresso.com/wiki/events-grid-view-template-add-on/#ee4customizations

And it’s ALL of that code you need to comment out, otherwise, the template is still doing all of the processing but just not outputting anything for it.


Bosworthsgc

September 12, 2017 at 2:56 am

HI Josh

yes – i deleted all of it

when it didnt seem to make a difference I put it back in

thanks


Tony

  • Support Staff

September 12, 2017 at 5:01 am

I suspect this is an issue with your host, in short it’s taking long time to pull in all of the details from the DB.

I created some events similar to yours, single datetime with ~15 tickets per event and then pulled them in using the Grid template without any issue.

I stopped at 40 events but didn’t notice any significant increase in waiting time, I also used the code above to pull the attendee limits for the events and again didn’t have any issues.

The test site I used for this is on a shared host and is their lowest plan so nothing special. You could try creating a ticket with your host to have them to investigate this further.

If you limit the events on the grid, to say 30 (add limit=30 to the shrotcode) does it speed up then? (My page loads within 3 seconds using 40 events)


Bosworthsgc

September 12, 2017 at 5:03 am

Thanks Tony

I will give this a try


Bosworthsgc

September 12, 2017 at 5:11 am

OK

I have as a test set the limit to 20.

When in the events page and selecting snowglobe it now loads much much faster

Obviously the problem I then have is that I have just short of 60 dates so need to show them all. Is there a way to click a “more” button or something to open the rest up?

Thanks


Tony

  • Support Staff

September 12, 2017 at 5:18 am

Not currently, you’d need the Grid template to use ajax and load X amount of events at a time.

You could split out the events into months and then load the events for each month on their own page so your loading 30ish events on the page. However as mentioned above, my host has no problem loading higher numbers of events similar to yours so your may be able to help.


Bosworthsgc

September 12, 2017 at 5:28 am

I will give them a shout

Thank you

Viewing 20 reply threads

The support post ‘Extremely slow speed processing an order’ 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