Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Re: [request] better / advanced search
Matthias, plugins that use MATCH in an SQL query using body/title columns (because that’s what the fullindex uses currently as columns), because the columns have to match exactly otherwise the query generates an error. I don’t know if any or how many plugins are affected and that’s what makes it tricky to change this in a stable release. It can be solved by adding a second index. This would make inserting articles a little bit slower, retrieving articles wouldn’t be affected, I think… but perhaps a MySQL expert can shed some light on that.
Another consideration is how much of an impact on search speed this would have as searching is done with RLIKE instead of MATCH and each extra column to search requires an extra RLIKE statement. Since excerpt is usually a lot smaller than body, I suspect that the impact is not that big, but it would have to be tested to make sure.
Last edited by ruud (2007-06-22 10:17:09)
Offline
Re: [request] better / advanced search
I’ve released the ob1_advanced_search. Since I am not a SQL or MySQL expert I can’t tell you how this changes the load on your server since it relies on MATCH (with creating new indexes where needed) as the original TXP search. It will increase your database size that’s for sure with those indexes.
Plugins: ob1_advanced_search 1.032b, ob1_search_score 1.0, ob1_pagination 2.5, ob1_title 4.1, ob1_modified 2.1
“Let your plans be dark and as impenetratable as night, and when you move, fall like a thunderbolt.”
— Sun Tzu
Offline