UBB.Developers Forums General Discussion Suggestions and Feedback About Search , why not use MySQL's FULLTEXT instead of SQL LIKE ?

Sorry , if this topic is discussed before ...

From original message :

[]Scream said:
Search - All forums all dates
6.4 Generated in .575 seconds. 8 queries took .203 of that time
6.5 Generated in .207 seconds. 8 queries took .089 seconds of that time
[/]
Just curious , how many posts are in your test forum ?
I have 300,000+ posts , and each search takes more than 1 min , and will probably cause serious table lock and server load ...
I am using 6.4.2
I have to remove search page and form , even registered users cannot search.
It is a serious problem ... ... ...

Why not use MySQL's FULLTEXT instead of SQL LIKE ?

The index of the fulltext search will require much diskspace, so it isn't suitable for every customer of ubb.threads.
I'm using the fulltext search on my 6.3.2 board for several months now and installed this modification for several clients also.
Apart from the fulltext search, using the UNION statement introduced in mysql 4.x will also help a lot.

[]Astaran said:
The index of the fulltext search will require much diskspace, so it isn't suitable for every customer of ubb.threads.
[/]

[:"red"]I would rather use more space to lower server load and increase system stability ...[/] Disk space is much more cheap now...


If possible , can Infopop or Scream write an instruction to tell us how to rewrite code to make use of MySQL's text index function ??
It is best that UBBThreads build-in two mode : MySQL with / without text index ...

Infopop won't "officially" provide you with any "hacks". That's why this site is here.

Yes, an optional use of the fulltext and union features would be nice, but afaik this isn't on the schedule for the next versions.
That's why I created my own one. It will not solve all bottlenecks of the search, but it improves the overall performance of it.
I haven't ported it to 6.4, but I'm looking forward to come up with an advanced one for 6.5.