Notice: CMSB v2.60 Beta 1 (Jan 30, 2014)
We've just released v2.60 beta 1 (beta list members will get an email with a download link shortly).
The major new feature are:
- Up to 150x speed improvements on mysql queries with built in support for custom columns types and column indexes
- OR searches in the CMS and all viewers, you can now show results that match ("one thing" OR "another"), not just exact matches
- Upgraded libraries: jQuery 1.11.0, jQuery UI 1.10.4, tinyMCE 3.5.10
- Lots of bug fixes and minor enhancements
If you're not already on the beta tester email list and you'd like to help beta test (you must own at least 1 CMSB license) you can sign up here: http://www.interactivetools.com/news/manage.php
Please post any feedback, questions, or bugs you find! Thanks!
One of the new features in v2.60 is the ability to easily assign custom mysql column types and creating search indexes for columns. For high traffic or slower sites, optimizing your column types and creating indexes can create a dramatic speed improvement.
I've attached a simple plugin called "v2.60 Index Speed Test". If you activate it from your Plugin Menu and click "Run Speed Test" it will run some sample queries that demonstrate the difference possible. I've also attached a screenshot showing the output of the plugin when it's run from this web server.
Note: Column types and indexes are a more advanced MySQL feature, so ease in slowly. A good rule of thumb is to optimize when needed. Don't just add indexes to every column without a specific reason or you'll make your site slower (indexes take up more disk space and increase memory usage). Google MySQL Indexes and MySQL Data Types for more details on each topic.
Please feel free to run this test and announce your results (or post a screenshot) below.
No, that's great. The plugin uses the same test data on every server. So you can see that when it uses the new features of "custom mysql column types" and "mysql indexes" you get a speed boost of between 7-109 times. So especially for queries that return a sorted list of results, you could run 100 queries in the same time it used to take to run one.
Going to run a test here shortly. One question...because the timing is impeccable. With one of the companies I host with they are in the middle of upgrading equipment and software (replacing where my accounts have been located for some time). In their notice this weekend they stated the MySQL version they are changing to is "called MariaDB" and it's supposed to work much faster. Are you familiar with this version and are you aware of any incompatibilities?