Previous Thread
Next Thread
Print Thread
Rate Thread
Joined: Jul 1999
Posts: 118
Enthusiast
Enthusiast
Offline
Joined: Jul 1999
Posts: 118
I think I have few searches, at least I never notice people in the 'who is online' being anywhere searching.

Can that be found somewhere? maybe in statistics? would be interesting how many searches happen.

I strongly suspect that a bunch of repeated searches could kill the server. 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.

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.

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!!

PS: I wonder if the bulk move plugin can help me archiving??

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.




Sponsored Links
Entire Thread
Subject Posted By Posted
How to do an archive forum to save CPU load? mario2 06/15/2003 10:55 AM
nobody can comment? it is a typical feature in other boards!! mario2 06/16/2003 9:47 AM
Re: nobody can comment? it is a typical feature in other boards!! JoshPet 06/16/2003 11:11 AM
Re: nobody can comment? it is a typical feature in other boards!! JustDave 06/16/2003 3:45 PM
Interesting!! small forums load faster both postlist and showflat!! mario2 06/17/2003 8:50 PM
I think this can save 1000's of $ in hardware cost for large ubbthreads mario2 06/17/2003 9:20 PM
Re: I think this can save 1000's of $ in hardware cost for large ubbthreads Astaran 06/18/2003 10:59 AM
My experiments SHOWED that this can save hardware cost for large ubbthreads mario2 06/18/2003 1:39 PM
admins should be able to restrict "search" privileges mario2 06/18/2003 1:42 PM
Re: My experiments SHOWED that this can save hardware cost for large ubbthr Astaran 06/18/2003 2:15 PM
Re: admins should be able to restrict "search" privileges Astaran 06/18/2003 2:16 PM
My board seems to have few searches, but search could be used for DNSattack mario2 06/18/2003 2:44 PM
Re: My board seems to have few searches, but search could be used for DNSat Astaran 06/18/2003 3:10 PM
Re: My board seems to have few searches, but search could be used for DNSat Dave_L_dup1 06/18/2003 3:35 PM
Re: My board seems to have few searches, but search could be used for DNSat Astaran 06/18/2003 4:01 PM
I implemented the archive forum& reduced CPU load from 80% to 20% mario2 06/30/2003 3:00 PM

Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
isaac
isaac
California
Posts: 1,157
Joined: July 2001
Forum Statistics
Forums63
Topics37,573
Posts293,925
Members13,849
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
WebGuy 2
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20240430)