Posted May 12May 12 Hi,Working on my testinstall after upgrade from 4.7 to 5, some of my Pages, has alot of revisions, for example 3 pages long.When there is not much content inside 1 revision it could load the full list of revisions. But for long pages, Chrome gives a popup "pages takes to long to wait" and when i click keep waiting, i can click this for 10times, and it still does not respond.On 4.7 it took also a long time to load, but those pages where loading. Now there not.I want to keep revisions turned on.How can i decrease the revision count on 1 page, that like there are only 5 revision loaded on a page. So it does not so long to load the revision page.CPU has 4cores.
May 13May 13 Community Expert If your server isnt coping with returning, then you would need to look at optimisation on your server. Its worth noting, the amount of cores your CPU has, doesnt really have any baring on the responsiveness of your site. If your server isnt configured to utilise resources efficiently, it will still be slow. You can check the followingGo to Support in your admin CP and ensure you have nothing showing here. Especially in the mysql section. If there is, you should address those firstSwitch on slow query logging, and capture what query is causing your issue
May 13May 13 Author No issues indentified. In admin CP supprt.Version 10.3.21-MariaDB-cll-lve Invision Community Version 5.0.7PHP Version 8.2.28Do i turn on slow query in invision or do i need to do this:slow_query_log = 1slow_query_log_file = /var/log/mysql/slow.loglong_query_time = 1
May 13May 13 Community Expert slow query logging is something you switch on in your msyql instance, not in your invision instance. If you are unsure how to do this, you would contact your hosting company to assist. Once you know what those issues are, please provide them here
May 13May 13 Community Expert MariaDB 10.3 is way too old and can cause slowness issues. You should upgrade that to at least version 10.11 if not 11.x.