Re: [Tiki-users] [Tiki-devel] Can't believe my eyes! :) Check the performance of tiki.org after some magic from Marc and a bit from me...

Oliver Hertel via TikiWiki-users <[email protected]> Wed, 28 Jul 2021 08:22:39 +0200

Newsgroups	gmane.comp.cms.tiki.user,gmane.comp.cms.tiki.devel
Message-ID	<[email protected]>

Hello Marc,

Wednesday, July 28, 2021, 4:32:37 AM, you wrote:

> Thanks Aris. I think 23.x has better performance than 22.x

> So themes and doc are at 23.x. while dev and community are coming soon. Schedule is here:
> https://dev.tiki.org/Tiki23

> So on this topic:

> 1- We made some quick changes and some things have improved. Here is a page to explain some of the tools we use: https://dev.tiki.org/Tiki23-dogfood-performance
> It's interesting how various services have wildly different scores.

> 2- I predict performance will drop again at one point because of a transient issue. Ex.: Too much traffic or server issues. Horia is setting up a server with Zabbix and NetData, which we'll use along with GlitchTip to pinpoint the issues.

Did you change something on tw.o, too? The Community page is broken now... 

https://tiki.org/Community

        Community
        Data too long for column 'description' at row 1

Can we actually check the data before writing them to the database? We already had tons of issues with that when we switch the utf8 version to 4 byte or  something. 
I had to manually adjust tw.o tables so they actually convert, because the data we had in there didn't fit in the fields with quadruple size.

And I guess this is once more just a statistics SQL, that really shouldn't break the page but rather die silently.

Cheers,
Oliver