Sorry , if this topic is discussed before ...<br /><br /> From original message : <br /><br />[]Scream said:<br />Search - All forums all dates<br />6.4 Generated in .575 seconds. 8 queries took .203 of that time<br />6.5 Generated in .207 seconds. 8 queries took .089 seconds of that time<br />[/]<br />Just curious , how many posts are in your test forum ?<br />I have 300,000+ posts , and each search takes more than 1 min , and will probably cause serious table lock and server load ... <br />I am using 6.4.2<br />I have to remove search page and form , even registered users cannot search.<br />It is a serious problem ... ... ...<br /><br />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.<br />I'm using the fulltext search on my 6.3.2 board for several months now and installed this modification for several clients also.<br />Apart from the fulltext search, using the UNION statement introduced in mysql 4.x will also help a lot.

[]Astaran said:<br />The index of the fulltext search will require much diskspace, so it isn't suitable for every customer of ubb.threads.<br />[/]<br /><br />[:"red"]I would rather use more space to lower server load and increase system stability ...[/] Disk space is much more cheap now...<br /><br /><br />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 ??<br />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. <img src="http://www.ubbdev.com/forum/images/graemlins/wink.gif" alt="" />

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.<br />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.<br />I haven't ported it to 6.4, but I'm looking forward to come up with an advanced one for 6.5.