Message of the day:
Welcome to SilverStripe | Current stable: https://goo.gl/C4F1T9 | Feature requests: https://goo.gl/EcQ34L | Community Forum: https://forum.silverstripe.org | StripeCon EU 2019! https://stripecon.eu
If you have any SilverStripe related questions, please supply the version of Framework you're using.
Did you flush? 🚽 =
XHGui is what I last used, which from memory was a wrapper project around MongoDB (for storing profiling data) and a nice-ish GUI on top of XHProf itself
@Aaron Cooper @null the main table is SiteTree_versions, Page_versions and Product_versions. I have a shop site and there is like 30k products (so pages) and every night they update pricing or a name or a description which writes a new record for almost every page. They also have a fairly big mega menu with lots of pages listed which im sure slows it down, I was wondering if a combo of removing old records and making the menu static would help. Or if there is something else? @theruss Do you have any links to XHProf that I can look into?
E.G. Vanilla SS3.6 on PHP 5.6 requests per second vs SS3.6 on PHP 7.1 requests per second. The benchmark is the same application on different PHP versions. Not combos of SS and PHP.
Same way all the others do. It's just a simple before and after focussing on PHP
I'd imagine that test would be skewed. Like how would you tell whether a perf improvement on SS4.4 on PHP7.3 over some other combo was down to SS itself or the PHP version?
Anyone seen any benchmarking done on any version of SS on PHP5 vs PHP7? Found lots of benchmarks for Wordpress, Drupal, Joomla and other nightmares. But no SS.
Tools such as XHProf will yield fascinating results 🙂
If you're having performance issues, your #1 port of call should always be to gain evidence, which will then direct you to where problems actually exist.
don't think it's the size that matters. It's how it's accessed and how often. Maybe a good chunk of that DB is 8GB of address records that form a lookup table. With certain columns indexed the large dataset won't be a huge issue.
With SilverStripe, I've found the largest table is the *_versions tables, which can slow it down if you depend on versioning a lot