|
ndaniel
|
September 19, 2012 at 9:10 am
Version: 3.1.26 We currently have 400+ events and 2,800+ attendees in the system. It seems the performance of the event and attendee screens is degrading as the volume of data increases. This is over https, which I have seen you mention as a concern, but it does seem the volume is the measurable concern, not the protocol. There have been no changes made to the hosting configuration. The performance was fine when volume was lower, perhaps 25% ago. Any suggestions on optimization for performance? This is becoming a true administrative burden. Other site features are responding well, including other EE pages.
Error on All Attendees page: Fatal error: Unknown: Cannot use output buffering in output buffering display handlers in Unknown on line 0
Cheers, Bill
-
This topic was modified 12 years, 2 months ago by
 ndaniel.
-
This topic was modified 12 years, 1 month ago by
 Garth. Reason: Moved to appropriate forum
|
|
Chris Reynolds
|
September 21, 2012 at 4:35 pm
We are constantly working on enhancing the performance of the database operations. That said, when you have a large database, it’s going to take significantly longer than when you have a small database. If you’re on a shared server it’s going to take longer than if you’re on a dedicated server. If your server runs the www and MySQL operations on the same server it’s going to take longer than if your host uses a separate server for the database and the website. When you have a ton of events and attendees, these minor tweaks matter a great deal because each one adds up.
With SSL, every single page request requires a check against the SSL security certificate to make sure it is valid, encrypts the data and then decrypts the data to display it. This adds a significant amount of loading time to every page that is running under https. And if there are multiple page requests, as in situations where items are being loaded from multiple places (for example the admin screens in Event Espresso that load a feed from the blog and the forums), those will get passed through the same process. So, adding this to the above, normal performance issues of having a large database and you’re going to have some problems.
Is there a specific reason why you need your admin SSL-encrypted? Are you storing credit card or HIPAA data in there, or is it just a security precaution (in which case, there are other methods of securing your site that you can take and SSL isn’t really adding a whole lot to those)?
|
|
ndaniel
|
September 28, 2012 at 4:41 pm
Thanks Chris. I had also posted this under premium. Seth mentioned there that there are optimizations being worked on. I was able to verify by monitoring processes that this is not the hosting structure that is an issue. HTTPS may be a very minor contributor, but I don’t think it is a measurable factor. I look forward to seeing the results of the tuned code.
Cheers,
Bill
|
