Simple:Press Version 5.5 – Innodb Support

update-newsWe have been intending – for a long time now – to write up more posts discussing the current state of developments for the next version of Simple:Press. And failing to do so! Now we plan to renew the effort but the first update, I am afraid, is a little techie and dry! Although it might just effect some users…

Using InnoDB MySQL Tables

Since the very start of Simple:Press we have created what is called a Full Text Index on our post and topic database tables. In simple terms, these indices help boost performance for searches. The problem with them is that with the vast majority of hosting companies, this type of indexing can only be created on what are called MyISAM tables. MyISAM is what is called a MySQL ‘engine’.

The main alternative to the MyISAM engine is a newer type called InnoDB. Newer and more efficient – especially on large databases with a lot of users all contending for access. But, except in rare cases, not supportive of Full Text Indexing.

The trade-off is obvious. Improve the performance of searches – traditionally a database intensive and relatively slow procedure . Or improve overall performance and let searches take just that little bit longer. Let’s be honest – we are mostly talking milliseconds here – but with a lot of users on-line and database queries and updates all contending for resources, those milliseconds can start to add up.

There is also the issue that just recently and every now and then we encounter a host who insists that tables be created using the InnoDB engine. So the issue clearly needed addressing.

With the next major update of Simple:Press (version 5.5.0) we will be dropping the need for the full text indexing mechanisms and supporting whatever table engine the server’s MySQL is set to by default. This might be MyISAM. It might be InnoDB. But Simple:Press will work happily on both.

At the same time we will also be releasing a small and simple WordPress plugin that will convert all of the Simple:Press MyISAM tables in your database – to use the InnoDB engine if this is something you prefer.

And I promise the next update post will be of greater interest to perhaps all users as we swing into test mode for our new Child Theme development planned to make display customisation even easier and secure from future updating.

Read Next

Did you find this article useful? Or do you use Simple:Press today?  If so, please support Simple:Press with a review on WordPress.org.  Every review goes a long way towards bringing other users on board!

Click here to review Simple:Press on wordpress.org

More From Simple:Press

What’s New In Simple:Press Forums 6.6.0

September 9, 2020

Simple:Press Forums 6.6.0 introduces two new major features and a lot of improvements to one of the existing features. And, of course, some bugs were stomped.

Read More

How We Increased Performance On Our Site By 300%

July 4, 2020

A few days ago we moved our site from Liquid Web to our new FireupWP and WPCloudDeploy project platform. This new platform allows us to use dedicated cloud VMs from places like Digital Ocean, Linode and Vultr. We pay the cost of the VMs with no markup which provides huge savings over regular hosts. We…

Read More

New Simple:Press Forum Theme: Modern 2020

March 5, 2020

A new default theme is coming to Simple:Press Forums with the release of Simple:Press Forums 6.5.0. Features of this theme: More modern looking with larger default font sizes and button sizes. Less use of tiny icons More color customization options Better display on mobile More white space Just like our previous default theme, Barebones, you…

Read More

Now Available: SPMS Version 2.7

January 10, 2020

Version 2.7 of Simple:Press Member Subscriptions is now available. It includes more than two dozen fixes and tweaks.

Read More