Website retrieval slower after upgrade to Joomla 5 and associated change to MySql 8 - Forum | JoomShaper
Staff replied SP Page Builder

Website retrieval slower after upgrade to Joomla 5 and associated change to MySql 8

Asked by Marco 2 years ago Last activity 2 years ago

Hello,

Have any of you ever noticed that after a DB migration from MySql 5.7 to MySql 8.0 the website responses are higher?

According to my provider, a MySql dump of the 5.7 DB and an import of this dump into a MySql 8.0 DB is sufficient.

Do I have to consider anything else from Joomla or from SP Page Builder?

Regards - Marco

5 replies

Oldest first Newest first Most helpful
Toufiq Senior Staff
2 years ago

Hi there,

Thank you for reaching out, and I apologize for any inconvenience caused by this oversight. I would request you to contact your hosting provider. I hope they can help you.

Best regards,

Toufiqur Rahman (Team Lead, Support)

Marco Asked this
2 years ago

Hello,

I have already contacted my hosting provider - the support assured me twice that the SQL dump of a MySql 5.7 database can simply be imported into a MySql 8.0 database - done.

Do you see it the same way from Joomshaper?

My question in this regard also goes in this direction, whether SP Page Builder can also use the new features of the MySql 8.0 database after such an import into the new database - list of features here (please translate yourself): https://www.easyname.at/blog/news-2/updates/mysql-8-das-solltest-du-wissen/

I miss the increase in speed of the pages that now run with MySql 8 databases - there is no difference to before, as written possibly even slower!

Regards - Marco

Paul Frankowski Senior Staff
2 years ago · edited

Marco, few technical details

  1. In general MySQL 8 is requested by Joomla Core itself, without you cannot even dream about Joomla 5.
  2. About MySQL version doesn't have big impact on the website speed, but it shouldn't be slower.
  3. From my private expirence, for over 3 weeks I test Joomla 5.03 + PHP 8.3 + SPPB 5.x and I see difference between PHP 8.0/8.1 vs PHP 8.3 in speed, all is smoother.
  4. And whether Joomla 5 is slower than Joomla 4 is a question for Joomla Team Developers.

We are not hosting support to give you tips what you can or not do in your Cpanel. But If you can:

  1. Turn on GZIP on the server for all objects.
  2. Check if you can use LiteSpeed or REDIS Cache.
  3. Add extra "speed-up & cache" code to .htaccess file.
  4. Check topics on forum.joomla.org what else you can do.

In general it's a topic for whole book or long article, not forum post.

Marco Asked this
2 years ago

Hello Paul,

thanks for your information.

So I take it from your answer that not much more needs to be done when converting the database - that's fine!

The few technical points are interesting - unfortunately I don't have PHP 8.3 available, my provider stops at 8.2.

Gzip is activated by default - I didn't know that myself before, but of course the provider releases his systems and I have set up redis, but it doesn't really do anything for me - I'll have a look at the .htaccess entries - thanks for that.

Regards - Marco

Paul Frankowski Senior Staff
2 years ago

Of course using PHP 8.2 is totally OK, it's faster & safer than PHP 7.4, 8.0 or 8.1.
I hope soon your Hosting company should implement PHP 8.3 - but more users have to ask for it, ask by FB etc.

You're welcome.

Log in to reply.