Quote:
Originally posted by sparky2
If you page through the contents of your WORD table though, using queries like this:
SELECT title FROM word where wordid>1000 and wordid<2000;
you would (anyone would!) have to agree that a large portion of the table's records contain "non-searchword" strings.
|
Well, I have gone through 0 to 10000 and my table is perfectly ok as you can see in the attachment..
Quote:
The purpose of the table is to store WORDS, not "junk".
|
I would say "words" is not the correct term.. The purpose of the table is to store "anything" in a post which can be used in a search string by a member in the future. And I believe "anything" should include every char, apart from * and <space>. Otherwise some boards specializing in different subjects as I mentioned in my previous message wouldnt be supported.
So I believe this structure of vb is right and if I were the developer of vb, I would code it in the same way. But if you are saying that this structure can be enhanced in a way that Admins would be able to restrict this behaviour according to their board's language, subject and charactaristics and set some custom striping rules, yes I would agree this would be a good enhancement.
And if you are looking for this enhancement (hack), you are in the right site either.