MySQL INSERT DELAYED directive

[sparky2]

Anyone care to offer an opinion as to whether using the DELAYED directive within the search.php INSERT queries might be beneficial toward easing/leveling the search-induced spikes in server load?

Thanks in advance.

[shovel]

No, it probably wouldn't make a bit of difference. I'd give it a quick experiment first, just to be sure. I remember awhile back I referenced to this same idea for a quick refresh of my bored, but I can't quite remember what I resulted with. If you would give it a try and post your findings I'd be real obliged. Thanks.

[Scott MacVicar]

If you want to ease load on the search then you possibly need to consider upgrading to MySQL 4 and fulltext index on the post column then you can use MySQL's full text searching.

[sparky2]

Thanks for the fulltext suggestion.
Before starting this thread, I had considered (and dismissed) using the LOW PRIORITY directive & had tried using the DELAYED directive -- it had no apparent effect.

[filburt1]

03-15-03 at 10:48 AM PPN said this in Post #3
If you want to ease load on the search then you possibly need to consider upgrading to MySQL 4 and fulltext index on the post column then you can use MySQL's full text searching.

Speaking of using FULLTEXT now in MySQL 4, would it be server-intensive to do a MATCH function to find posts related to given keywords, or is the searchindex still better?