[]
mario2 said: Can that be found somewhere? maybe in statistics? would be interesting how many searches happen.[/]
No, but there is a hack arround here that tracks the search values. You could alter your dosearch.php to log all submitted queries, also.
[]
I strongly suspect that a bunch of repeated searches could kill the server.
[/]
Not kill, but cause swapping so that mysql reaches the max connection limit. That makes the board unusable for a certain amount of time.
[]
So one more reason for doing more control on allowed searches! Should be more options for the webmaster to partially allow searches, or only for certain paying members.[/]
I agree, but this can easily be hacked.
[]
Well my test result showed a 10 fold speedup for a 1000 post forum compared to a 150 000 post forum. This is VERY VERY DRAMATIC? Because this was on the showflat and postlist, which most people use all the time. [/]
Thats quiet normal, mysql needs to scan more rows until it can process the result.
[]
That means we could get by with 5% cpu load instead of 50%. This is very very very dramatic and relevant. Please read again, don't just talk that away!![/]
Don't mix the query time with cpu load. A 10 times slower query time doesn't mean that the cpu load is 10 times higher!
[]
PS: I wonder if the bulk move plugin can help me archiving??
[/]
Sure, if you want to archive the threads by hand
[]
Can some mysql whiz help me to find the command for
move all posts with less than 3 days age from forum xxx to forum xxxarchive?
instead of age, post number higher than nnn would also do.
[/]
[:"red"]Note: this queries should not be used to backup old threads! [/]
<br />UPDATE w3t_Posts <br />SET B_Board ="ARCHIVEBOARDKEYWORD" <br />WHERE B_Number < POSTID; <br /> <br />UPDATE w3t_Posts <br />SET B_Board ="ARCHIVEBOARDKEYWORD" <br />WHERE B_POSTED < TIMESTAMP OF DATE; <br />