GW search engine is from 1998
|
Actually
|
Posted 6:13 pm, 05/17/2022
|
Look, the search results change every time.
|
|
Actually
|
Posted 6:12 pm, 05/17/2022
|
Relevance Last Post TOPIC
| REPLIES
| AUTHOR
| LAST POST
|
|
|
|
Actually
|
Posted 5:49 pm, 05/17/2022
|
Jason convince us how a post from 2006 about John Parsons should be the top result for "Big girls"
|
|
Actually
|
Posted 5:48 pm, 05/17/2022
|
Lol at the search engine!
Search again and you get entirely different irrelevant results!
#1 was a post from 2006 called "John Parsons".
Worthless search engine.
|
|
Actually
|
Posted 5:44 pm, 05/17/2022
|
Here is an example of the very lame and non working search engine
Search for "big girls"
Why would an active post from a few days ago "Big girls on strike". Not be a top result? Look at what shows up in the search.
Yeh, it does not work well at all. Code harder.
|
|
robina
|
Posted 5:26 pm, 05/17/2022
|
That's the most I seen Mr. Gowilkes on here
|
|
aFicIoNadoS
|
Posted 7:21 am, 05/17/2022
|
Jason, I don't have to be a mechanic to recognize the difference in performance between a porche and an 87 Pontiac lemans. Your defensiveness of "oh yeah, let's see you do better" instead discussing what makes your system good only suggests you know the OP's criticism is correct.
|
|
GoWilkes
|
Posted 12:28 am, 05/17/2022
|
I know, but I still wanted it to be known that I'm totally open to suggestions! If someone can suggest something that improves my business, I'm always listening 
I've never been in love with the search engine, either, but I've yet to find a better option. Pretty much every site I've seen does it one of three ways:
1. MATCH..AGAINST, like I do;
2. Redirect to Google; or
3. Extract keywords from posts and store them separately, so that a search query uses those keywords instead of the full thread. I've done a lot of work to try to implement that here, but there's no good automated system to extract keywords like that. This is the type of system that's more common on ecommerce sites, where the person entering products to the catalog can manually assign keywords.
If there's a fourth option, believe me, I'd love to see it!
|
|
Acumen
|
Posted 12:07 am, 05/17/2022
|
Jason, they are trolls messing with you.
|
|
GoWilkes
|
Posted 11:41 pm, 05/16/2022
|
If either of you want to show me the code for how "any other forum does it", I'll be more than happy to make those changes. I've been trying to improve it for several years, so if you guys know some place to look that I don't then please do share!
|
|
Actually
|
Posted 10:02 pm, 05/16/2022
|
Very low level coding with the search engine, it clearly does not perform well. Test it once in awhile. It's no longer 1998 bro.
|
|
aFicIoNadoS
|
Posted 6:58 pm, 05/16/2022
|
Well, you could copy how any other forum does it.
|
|
GoWilkes
|
Posted 6:47 pm, 05/16/2022
|
Well this is disappointing, I was sure that the OP would have some coding advice! Oh well 
As you can see, though, the existing code reads through the usernames and posts for whatever the search term is. Threads with that term appearing more often will have the higher score, so those threads show up first in the results.
But MariaDB (and all databases, really) have words that they ignore by default: "the", "of", "as", etc. This includes most adverbs and adjectives, so searching for "actually", for example, would show 0 results.
|
|
GoWilkes
|
Posted 8:25 pm, 05/15/2022
|
Here's the MariaDB query, if you know how to make it better than I'm all ears
SELECT DISTINCT cv_posts.id, MATCH (username, comment) AGAINST('%s' IN BOOLEAN MODE) AS score FROM cv_posts WHERE MATCH (username, comment) AGAINST ('%s' IN BOOLEAN MODE) ORDER BY score DESC
|
|
|
