Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
news-topic
Simple:Press Version 5.5 – Innodb Support
Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Apr 30, 2014 - 3:43 pm
sp_QuotePost Quote

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.

andy-signature.png
YELLOW
SWORDFISH
Avatar
kvr28
Member
Free Members
sp_UserOfflineSmall Offline
Apr 30, 2014 - 6:10 pm
sp_QuotePost Quote

This affects me and any others who host on wpengine, and I appreciate your work on this Yellow, 2 weeks now and no one has said there is a issue with search at all

 

again, thank-you 

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Apr 30, 2014 - 8:58 pm
sp_QuotePost Quote

no eta on version 5.5, but should be early this summer - maybe earlier depending on where wp takes 4.0...

Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 619
Members: 17361
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10127
Posts: 79625