Support Forum

Well as you are feeling brave let's go for it!

The attached file is called sp-search-view-class.php and it needs to be located at:

/simple-press/forum/content/classes/

You will see the current file at that location. I would recommend that you do not overwrite this but rename it so that you can juggle them back quickly and easily if you encounter any problems.

Please do remember that this is very much beta/in-progress work. Good news is it can do no damage as it only queries of course. The only real concern is if it is (a) returning data at all when searching and (b) the correct data! It should be as the queries are fairly straightforward. It is more the permutation of options that needs further testing.

And this code should work with either the MyISAM or InnoDB storage engine. It males no use of the FULLTEXT index. Note that there are three tables overall that have a FULLTEXT index. These are sfposts, sftopics and sftags which you will only have if you have the Simple:Press Tags plugin activated.

So please do go ahead and let us know how it goes. It was always the plan that our targeted 5.5.0 release would investigate and support the InnoDB storage engine so you will be the first to try it out! Thanks for that.

Note the file does need unzipping. An obvious point but not everyone realises that as we have found in the past!

The main thing is to make sure it works with all the different permutations under the Advanced Search options. I.e., phrase, all words, with and without topic titles etc.

It seems to be holding up fine with my own testing but there is nothing like handing code to a user to break

Thanks for the update., I hope to get it live on our site as well over the next few days.

On the first question we expect that this version will become the regular version of the file.

It is perhaps worth mentioning the pros and cons of innoDB tables over the more regular myISAM tables. It is true that they are generally more efficient. This is only really going to have any noticeable effect on a very busy site where there are lots of users in contention for database queries. In those circumstances there is no doubt that InnoDB are best. The downside is that without Fulltext index support, searches will be slower. Again - not really noticeably but certainly measurably.

But that does suggest that search takes a small hit for the good of the rest and when you put it that way it is probably a good thing. So - our next development cycle always had InnoDB support as a main feature point. This means that the search code you have will remain in core unless something drastic turns up in testing. I have also, over the last couple of days, written a plugin that gives a UI to any users wishing to upgrade their forum tables to InnoDB and removed any preference for MyISAM tables that existed up to 5.4.2.

On to the second question. This is actually much harder than it sounds. We started to do this once and had to pull back because getting it right is difficult, prone to error and does, believe it or not, have quite a major impact in performance. So currently I am afraid there are no immediate plans to resurrect this but it remains on the future development list as something we do want to conquer at some point.