![]() |
MySQL INSERT DELAYED directive
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. |
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.
|
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.
|
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. |
Quote:
|
All times are GMT. The time now is 08:13 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|