Can't search for three-letter words?

[XTF]

Hi,

It used to be possible to search for three-letter words, like XBT. Why is this no longer possible?

[Paul M]

We now use the mysql full text search, and the minimum size is four letters.

[XTF]

We now use the mysql full text search, and the minimum size is four letters.
If you don't change the default configuration. So, could you change the configuration to 3?

[Paul M]

No we cannot, we have no control on such matters - we run on the main Jelsoft servers (that all Jelsofts sites run on) and I doubt they will want to reduce the setting to three.

[XTF]

No we cannot, we have no control on such matters - we run on the main Jelsoft servers (that all Jelsofts sites run on) and I doubt they will want to reduce the setting to three.
Why do you doubt that?

[Ziki]

So why not switching back to vb search again?

[Ntfu2]

cause then you could search for things like 'png fix' and find the thread for it.

[XTF]

cause then you could search for things like 'png fix' and find the thread for it.
And that would be bad because ...?

[Ntfu2]

Cause then we could find things we are looking for?

/sarcasim.

[Brad]

So why not switching back to vb search again?
This change was made because searching was causing search.php to time out and throw an error due to the number of records it was having to sort through. While it's possible to allow 3-letter words to be searchable with FULLTEXT searching turned on it's not something that can be changed from the admincp. Allowing 3-letter words would also fill the index up with a ton of new data that is bound to slow searching down again.

It's a catch-22 until someone comes up with a better way of searching records in a mySQL database. If your forum ever gets as large as this one you'll have the same problem. :)

[orban]

There's a nice thread in the big boards forum about searching :) Though I doubt vB will run the search for their forums to show their software with a not-built-in software :P

[Ziki]

This change was made because searching was causing search.php to time out and throw an error due to the number of records it was having to sort through. While it's possible to allow 3-letter words to be searchable with FULLTEXT searching turned on it's not something that can be changed from the admincp. Allowing 3-letter words would also fill the index up with a ton of new data that is bound to slow searching down again.

It's a catch-22 until someone comes up with a better way of searching records in a mySQL database. If your forum ever gets as large as this one you'll have the same problem. :)

and what about google search :p

[Kirk Y]

and what about google search :p
ROTFL... :D

[Adrian Schneider]

and what about google search :p
I don't think Google uses MySQL. ;)

I prefer fulltext indexing over the standard vBulletin one... it's actually easier to use if you know about it. Of course you are screwed with the short words anyway, but as Ziki (probably unknowingly) suggested you can search on Google to find things on this site.

http://www.google.ca/search?q=site:vbulletin.org png fix

[XTF]

I don't think Google uses MySQL. ;)

I prefer fulltext indexing over the standard vBulletin one... it's actually easier to use if you know about it. Of course you are screwed with the short words anyway, but as Ziki (probably unknowingly) suggested you can search on Google to find things on this site.

http://www.google.ca/search?q=site:vbulletin.org png fix
But that's not as useful as the search of the forum itself, since the results are displayed completely different.

[Ziki]

but as Ziki (probably unknowingly)

lol it was a joke :D

[calorie]

Throw an asterisk onto three-letter words. Example: xbt* (https://vborg.vbsupport.ru/search.php?do=process&q=xbt*)

[Ziki]

oh forgot about those.good point calorie

[XTF]

Throw an asterisk onto three-letter words. Example: xbt* (https://vborg.vbsupport.ru/search.php?do=process&q=xbt*)
That doesn't work. It searches for words of at least four letters that start with xbt.