Previous Thread
Next Thread
Print Thread
Hop To
Joined: Sep 2004
Posts: 152
Y
member
member
Y Offline
Joined: Sep 2004
Posts: 152
http://forums.atril.com/ubbthreads7/ubbthreads.php?ubb=showflat&Number=184#Post184 features the word DVX. However, this term cannot be found - no term of 3 letters or less is found actually, even though I have explicitly set the minimum length of search terms to 2 letters.

The maximum number of results is set to 200, but I'm 100% sure the abbreviation DVX only occurs a few times on the forum.

How come?

Last edited by Yomar; 12/03/2007 8:14 PM.
Joined: Nov 2006
Posts: 3,095
Likes: 1
Carpal Tunnel
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095
Likes: 1
It is a multi faceted issue.

1. MySQL needs to be enabled to support search terms under 4 characters

2. It must not be one of the STOPWORDS of MySQL STOPWORDS

3. Not sure if UBBT has any specific entries to prevent it or not (don't think so)

However - MySQL and most other sites HIGHLY recommend that you do not allow search terms less than 4 characters as it will potentially place a very large load on your server resources.

That said, most ISP will not allow it to be enabled.

Joined: Sep 2004
Posts: 152
Y
member
member
Y Offline
Joined: Sep 2004
Posts: 152
Ah, okay - that explains everything then! Thanks a lot.

Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
Perhaps another FAQ forum update is needed... This seems to come up more and more


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Jun 2006
Posts: 3,837
I
Ian Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,837
I think the confusing issue here is that other forums seem to include 3 as standard - and they can't all be getting their hosts to alter MySQL config.

Joined: Nov 2006
Posts: 3,095
Likes: 1
Carpal Tunnel
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095
Likes: 1
Well there are other ways to do the search - I've not really looked at the other offerings to see how or what they're doing.

Joined: Dec 2003
Posts: 1,796
Pooh-Bah
Pooh-Bah
Joined: Dec 2003
Posts: 1,796
Originally Posted by Ian
I think the confusing issue here is that other forums seem to include 3 as standard - and they can't all be getting their hosts to alter MySQL config.


I believe vb's minimum is 4, not sure about the others.


- Allen
- ThreadsDev | PraiseCafe
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
Well, 3-4 are standard character lengths, they simply throw out a warning about anything less than 4... Do they even allow you to search anything less than 4 in VB?

I believe that Rick is planning to return the "old" search to a version down the road, where users could search any length their heart desires...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
it's not only length that matters (no peanut gallery comments plz)..

but frequency.. the full text index won't the most common words.. or effectively those that appear with a relevancy of 50% (don't hold me to the number) or more..

ie: assume you had a forum about basket weaving... the possibility exists that the word 'basket' appears too often and therefore the index won't match on basket...

there is a lot more to it than just the simple example i give, but i wanted to bring that up wink

Joined: Jun 2006
Posts: 3,837
I
Ian Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,837
VB is often three characters.

Joined: Sep 2004
Posts: 152
Y
member
member
Y Offline
Joined: Sep 2004
Posts: 152
Well, the thing is that if I make a test script in PHP and look for the word "the" in UBB's database, I get thousands of hits without problems...

So why doesn't UBB.threads do the same? Once more: the minimum length in UBB.threads is set to 3.

Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
show me your test script smile

Joined: Aug 2006
Posts: 1,358
Y
Veteran
Veteran
Y Offline
Joined: Aug 2006
Posts: 1,358
Originally Posted by Sirdude
show me your test script smile


probably something with like %the%. ubb utilizes the full text search index, and uses MATCH. A lot faster, but with limitations.


[Linked Image from siemons.org]
Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
that's why i asked wink

Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
Yeh, likely you're matching against the db with a method that isn't fulltext searching... That's why the old search method will be making a comeback in a future release (to those who want to use it)


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Dec 2007
Posts: 1
P
stranger
stranger
P Offline
Joined: Dec 2007
Posts: 1
if_you_use_underscores_for_small_words_it_helps_i_hear

Joined: Sep 2004
Posts: 152
Y
member
member
Y Offline
Joined: Sep 2004
Posts: 152
Quote
probably something with like %the%. ubb utilizes the full text search index, and uses MATCH. A lot faster, but with limitations.

True, I used like %the%.

So with MATCH (whatever that is, I'll have to look into that), the MySQL system variable ft_min_word_len kicks in, but with LIKE it doesn't?

Quote
if_you_use_underscores_for_small_words_it_helps_i_hear

Unfortunately that doesn't do anything for me.

Joined: Aug 2006
Posts: 1,358
Y
Veteran
Veteran
Y Offline
Joined: Aug 2006
Posts: 1,358
Originally Posted by Yomar
So with MATCH (whatever that is, I'll have to look into that), the MySQL system variable ft_min_word_len kicks in, but with LIKE it doesn't?

Yeppers, that's it. It is loads faster because it search an index instead of the actual data. The old search will have a comeback in ubb.threads for smaller/medium sized boards.


[Linked Image from siemons.org]
Joined: Sep 2004
Posts: 152
Y
member
member
Y Offline
Joined: Sep 2004
Posts: 152
Quote
Yeppers, that's it. It is loads faster because it search an index instead of the actual data. The old search will have a comeback in UBB.threads for smaller/medium sized boards.

Any ETA for that blaaskaak? LIKE is on top of my wishlist!

Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
Too much was packed into 7.3, so you'd be looking at 7.4 at minimum


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
7.3.x smile


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
1 members (Ruben), 476 guests, and 111 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)