|
Joined: Sep 2004
Posts: 152
member
|
member
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
member
|
member
Joined: Sep 2004
Posts: 152 |
Ah, okay - that explains everything then! Thanks a lot.
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 Likes: 116 |
Perhaps another FAQ forum update is needed... This seems to come up more and more
|
|
|
|
Joined: Jun 2006
Posts: 3,837
Carpal Tunnel
|
Carpal Tunnel
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 |
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.
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 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...
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
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
|
|
|
|
Joined: Jun 2006
Posts: 3,837
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837 |
VB is often three characters.
|
|
|
|
Joined: Sep 2004
Posts: 152
member
|
member
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
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
show me your test script
|
|
|
|
Joined: Aug 2006
Posts: 1,358
Veteran
|
Veteran
Joined: Aug 2006
Posts: 1,358 |
show me your test script probably something with like %the%. ubb utilizes the full text search index, and uses MATCH. A lot faster, but with limitations.
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
that's why i asked
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 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)
|
|
|
|
Joined: Dec 2007
Posts: 1
stranger
|
stranger
Joined: Dec 2007
Posts: 1 |
if_you_use_underscores_for_small_words_it_helps_i_hear
|
|
|
|
Joined: Sep 2004
Posts: 152
member
|
member
Joined: Sep 2004
Posts: 152 |
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? 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
Veteran
|
Veteran
Joined: Aug 2006
Posts: 1,358 |
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.
|
|
|
|
Joined: Sep 2004
Posts: 152
member
|
member
Joined: Sep 2004
Posts: 152 |
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,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 Likes: 116 |
Too much was packed into 7.3, so you'd be looking at 7.4 at minimum
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
7.3.x
|
|
|
|
Bots
by Outdoorking - 04/13/2024 5:08 PM
|
|
|
2 members (Ruben, 1 invisible),
850
guests, and
182
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|