Hi

xoops uses a SQL LIKE '%foobar%' Syntax to do fulltext seach on forum posts, comments, news...

This takes quite a lot of performance. You can even start a DOS Attack by simply doing a lot of searching in a short period.

There is a mySQL FULLTEXT search index which should solve this problem. You also have to rewrite the queries. Is there any reason why XOOPS still uses the slow LIKE criteria? Is there a hack available?

greetings
birdseedmusic

Hi

*push*

hoping for answers... ;)

greetings
birdseedmusic

because fulltext search is a hack-like technique considering its capability for multibyte languages.