|
Venkatraman Pichumani
|
September 16, 2014 at 12:08 am
Hello Event Espresso Team,
We have been using Event Espresso for quite a long time and it works nicely. Lately, our users are experiecing the problem with the form submission. They feel that site is running slow. We turned on MySQL slow query log to check if there is any query because of which it is running slow. We found that the query which is executed on the ‘Confirmation Display’ Page takes lot of time and because of that total page load time is getting affected.
Also, on admin side, page used to time out when we tried to export the attendee data. We changed the PHP time limit but it did not work. Later, we found that MySQL was consuming lot of memory. Hence, we separated MySQL to another server and from that time it is working smoothly. But we are afraid that in future, we may again come across with this issue.
So to avoid this kind of issue after having large database, can we have event specific tables in database Or would you suggest some other solution to this problem?
Thanks.
|
|
Sidney Harrell
|
September 16, 2014 at 11:05 am
Looks like you are on 3.1.30.7P, is that right? The 3.1 version is up to 3.1.36.5, but for long term, you really want to be looking to EE4. Once of the reasons for the ground up rewrite that became EE4 was to optimize the underlying DB schema.
Efficiency of code can help with the scaling factor, but increases in traffic or growth in database size can only be addressed by scaling and network engineering. If you are forced to grow from shared hosting, to a VPS, to a managed server, to renting rack space to mount your own servers, it sounds like a good problem to have.
|
