vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin.org Site Feedback (https://vborg.vbsupport.ru/forumdisplay.php?f=7)
-   -   Can't search for three-letter words? (https://vborg.vbsupport.ru/showthread.php?t=134285)

XTF 12-18-2006 03:02 PM
Can't search for three-letter words?
 
Hi,

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

Paul M 12-18-2006 03:26 PM
We now use the mysql full text search, and the minimum size is four letters.

XTF 12-18-2006 04:11 PM
Quote:
Originally Posted by Paul M (Post 1141017)
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 12-18-2006 04:59 PM
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 12-18-2006 05:48 PM
Quote:
Originally Posted by Paul M (Post 1141067)
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 12-18-2006 05:59 PM
So why not switching back to vb search again?

Ntfu2 12-18-2006 08:44 PM
cause then you could search for things like 'png fix' and find the thread for it.

XTF 12-18-2006 08:50 PM
Quote:
Originally Posted by Ntfu2 (Post 1141180)
cause then you could search for things like 'png fix' and find the thread for it.
And that would be bad because ...?

Ntfu2 12-18-2006 09:30 PM
Cause then we could find things we are looking for?

/sarcasim.

Brad 12-18-2006 11:57 PM
Quote:
Originally Posted by Ziki (Post 1141098)
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 12-20-2006 01:04 PM
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 12-20-2006 04:47 PM
Quote:
Originally Posted by Brad (Post 1141309)
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 12-21-2006 07:32 AM
Quote:
Originally Posted by Ziki (Post 1142324)
and what about google search :p
ROTFL... :D

Adrian Schneider 12-21-2006 08:40 AM
Quote:
Originally Posted by Ziki (Post 1142324)
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:v...in.org png fix

XTF 12-21-2006 01:43 PM
Quote:
Originally Posted by SirAdrian (Post 1142702)
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:v...in.org png fix
But that's not as useful as the search of the forum itself, since the results are displayed completely different.

Ziki 12-22-2006 02:57 PM
Quote:
but as Ziki (probably unknowingly)
lol it was a joke :D

calorie 12-22-2006 09:14 PM
Throw an asterisk onto three-letter words. Example: xbt*

Ziki 12-27-2006 08:20 PM
oh forgot about those.good point calorie

XTF 12-29-2006 07:50 PM
Quote:
Originally Posted by calorie (Post 1143688)
Throw an asterisk onto three-letter words. Example: xbt*
That doesn't work. It searches for words of at least four letters that start with xbt.


All times are GMT. The time now is 11:35 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01104 seconds
  • Memory Usage 1,752KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (10)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (19)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete