jeremyneas 0 #1 November 24, 2003 Ok, when the posts are archived, like say on page 998. Do they get archived by the date of the last posted message? or the first? If it's the first, when does the message place back into it's position? For instance, lets say i added something to the very first post...would it bump up to the front here and wedge down slowly, or bounce back after a while of non-use? Quote Share this post Link to post Share on other sites
PhreeZone 20 #2 November 24, 2003 It is based on date of last post to a thread for display. If you were to bump a thread it would slowly filter down the list till it gets buried too deep for casual users to dig it up and it would be buried. I'd love to see everything in Talkback over a year old removed from the search function. It would take some load off the processors and it would keep old threads from coming back from the dead unless some one specifically looked for them.Yesterday is history And tomorrow is a mystery Parachutemanuals.com Quote Share this post Link to post Share on other sites
Jimbo 0 #3 November 24, 2003 QuoteI'd love to see everything in Talkback over a year old removed from the search function. It would take some load off the processors Doubtful, judging from the number of threads that are either reposts, or asking a technical question that has been answered numerous times, I don't think that the search function and searching of old threads is a big CPU hog. The big CPU hog, I suspect, is the database hit everytime someone jumps to the forums page, opens or reloads a forum, and opens, or probably more importantly, responds to a thread. Quoteand it would keep old threads from coming back from the dead unless some one specifically looked for them. Looked for them how? By searching? - Jim"Like" - The modern day comma Good bye, my friends. You are missed. Quote Share this post Link to post Share on other sites
PhreeZone 20 #4 November 24, 2003 Actually search is a pretty intensive CPU function in a SQL environment. It has to look in every searchable record for the string being searched against. Running in an optimized environment helps since it creates pointer tables to assist and reduce work load having everything indexed, but its still a really intensive function to do. Writing to a DB is a very low overhead on a CPU, its when the data is altered or used is when the CPU hit comes in at. >Looked for them how? By searching? By knowing when the original post was and by jumping page by page back till they get to that time frame. Like if you wanted to joke with Viking on the aniversery of him having sex you would need to actually know the general time frame to go back to unlike today and searching for strings and replying to bump it up. Most of talkback that is over a year old is forgotten info anyways. But it is still in the search function so everytime a search is ran against the DB everything gets searched.Yesterday is history And tomorrow is a mystery Parachutemanuals.com Quote Share this post Link to post Share on other sites
Jimbo 0 #5 November 24, 2003 QuoteActually search is a pretty intensive CPU function in a SQL environment. I'm not disputing that searches are CPU hogs. My claim is that I suspect that they don't happen nearly enough around to make a significant difference in the performance of the site. QuoteMost of talkback that is over a year old is forgotten info anyways. But it is still in the search function so everytime a search is ran against the DB everything gets searched. Correct, it's still being searched. If there is a concern about site performance it makes sense to address the big problems first and the smaller problems later. As I mentioned in my original post, I suspect that the search function is not utilized nearly enough to have a noticible impact on site performance. As far as jumping page, by page, by page... Bad idea, it's important to maintain the functionality of the site through any performance tuning efforts. - Jim"Like" - The modern day comma Good bye, my friends. You are missed. Quote Share this post Link to post Share on other sites
sangiro 26 #6 November 24, 2003 An easy solution not to search for everything is to use the "Show posts from the last" field. These forums are indexed. A search does not go though every record every time.Safe swoops Sangiro Quote Share this post Link to post Share on other sites
PhreeZone 20 #7 November 24, 2003 Oh... I use the Show posts fields, and I usually filter by as much as I can too Since you are reading this thread.. .want to kick us some numbers if you have them on what % processor utilization is being used on what tasks? Yesterday is history And tomorrow is a mystery Parachutemanuals.com Quote Share this post Link to post Share on other sites
