posted on Nov, 22 2008 @ 11:56 AM
reply to post by malignant_tumor
I guess I misunderstood what you meant... After re-reading your OP I see now that you meant a system that would present the existing threads that had
the keywords in them for the member to review to see if the existing thread covers what (s)he wants to discuss.
If the existing thread(s) covered the topic then the member should add to the existing thread rather than create a new one, is that about right?
That's actually a pretty good idea but unfortunately with a database approaching 100Gigs it would bring the entire site to a grinding halt. With a
system like this, every time someone hit submit on a new thread a HUGE query would be initiated that scoured the entire database.
On a smaller site it would work well, a site that had a db that was only a few megabytes and didn't have hundreds of people all hitting that database
at the exact same Nano second would be able to do this.
Heck, we had to kill Boolean search for this very reason and it was no where near the intensity of load on the db server a system like this would
be.
It's one of the downsides to explosive growth, the technology available is not optimum because there just aren't that many sites like ATS that have
the intense traffic and content we do. In other words, there hasn't been enough demand to justify the development expense to create customized
solutions for sites like ours.
An example of what I mean is the fact SkepticOverlord had to take an off the shelf version of PhP and create what can honestly be called a completely
customized, proprietary version we call "AboveTop:Board v2.3". He had to do this because the standard PhP products out there just aren't capable
of running this site.
Springer...
[edit on 11-23-2008 by Springer]