Conjunctive Searches?
#1
Rennlist Member
Thread Starter
![Default](https://rennlist.com/forums/images/icons/icon1.gif)
Is it possible to search for two words, both of which must be present? I'd like to search for a source for a radio removal tool, but cannot figure out how to search for radio and removal. The default search seems to be radio OR removal, and that is overborad.
#3
Rennlist Member
Thread Starter
![Default](https://rennlist.com/forums/images/icons/icon1.gif)
Nope. Here's how that is parsed: "gt3 OR seat" OR leather.
There is so much great info here, but the search function is crippled, or not turned on!
Help!
There is so much great info here, but the search function is crippled, or not turned on!
Help!
#4
Banned
![Default](https://rennlist.com/forums/images/icons/icon1.gif)
Hi Chris,
Actually - the SEARCH function works great - but, with nearly 2,000,000 posts to index containing multiple "words" - the search results are limited to the first 500 most relevant posts in the search return.
For example try this:
Open "advanced search" and search ONLY the 911 Forum. Use the exact prase:
transmission AND oil
and you will see about 65 threads are returned.
But - if you search:
transmission OR oil
you'll see that 500 threads are returned with the search words highlighted. Now - if you want to go beyond the 500 most relevant topics/posts - select "find posts from" to move the seach query back farther.
I'd suggest that if anyone gets 500 threads to read - they may want to tighten up their search terms a bit, as there isn't anyone who is going to read all 500 threads anyway![Wink](https://rennlist.com/forums/images/smilies/wink.gif)
Best to you,
John
Actually - the SEARCH function works great - but, with nearly 2,000,000 posts to index containing multiple "words" - the search results are limited to the first 500 most relevant posts in the search return.
For example try this:
Open "advanced search" and search ONLY the 911 Forum. Use the exact prase:
transmission AND oil
and you will see about 65 threads are returned.
But - if you search:
transmission OR oil
you'll see that 500 threads are returned with the search words highlighted. Now - if you want to go beyond the 500 most relevant topics/posts - select "find posts from" to move the seach query back farther.
I'd suggest that if anyone gets 500 threads to read - they may want to tighten up their search terms a bit, as there isn't anyone who is going to read all 500 threads anyway
![Wink](https://rennlist.com/forums/images/smilies/wink.gif)
Best to you,
John
#5
Rennlist Member
Thread Starter
![Default](https://rennlist.com/forums/images/icons/icon1.gif)
When i search for "antenna AND cb*" it is parsed as "antenna OR cb*" according to the top of the search results page. When I enter transmission AND oil it gets parsed as Search: Key Word(s): transmission OR oil ; Forum: 911 Forum and child forums.
Clearly I'm doing something wrong!
Clearly I'm doing something wrong!
#6
Banned
![Default](https://rennlist.com/forums/images/icons/icon1.gif)
OK - try it without the quotes... If you do - the parse structure will be:
Search: Key Word(s): transmission, oil without the OR statement....
Let me know if that works..?
John D.
Search: Key Word(s): transmission, oil without the OR statement....
Let me know if that works..?
John D.
#7
Rennlist Member
Thread Starter
![Default](https://rennlist.com/forums/images/icons/icon1.gif)
I did it without the quotation marks.
When I enter
transmission AND oil
what I get is Search: Key Word(s): transmission OR oil ; Forum: 911 Forum and child forums and 500 hits for full text searches.
I sorted the results by relevence, BUT when I change the sort to last posting date it works and I get the 65 hits you noted.
Thank you for sticking with me on this! Are there any other search terms that work with this software? Is * a wildcard for multiple characters and ? for a single character? Should OR and AND be in all caps, or does it matter? This is such a GREAT resource!
When I enter
transmission AND oil
what I get is Search: Key Word(s): transmission OR oil ; Forum: 911 Forum and child forums and 500 hits for full text searches.
I sorted the results by relevence, BUT when I change the sort to last posting date it works and I get the 65 hits you noted.
Thank you for sticking with me on this! Are there any other search terms that work with this software? Is * a wildcard for multiple characters and ? for a single character? Should OR and AND be in all caps, or does it matter? This is such a GREAT resource!
Trending Topics
#8
Banned
![Default](https://rennlist.com/forums/images/icons/icon1.gif)
Aww - no problem!!
Also - what browser are you using - as I'd like to recreate what you are seeing..???
A few comment - the AND, OR, NOT (depending on what you are looking for) in the phrase structure should be capitals (but, it really shouldn't matter - but...
) For example:
transmission AND oil should be the same as transmission and oil As well - the wildcard "*" can be used as a prefix or a suffix - or both! So... *miss* should bring up "transmission" while "miss*" would bring up mission...
So - let's say you were looking for just "wing antennas" in the 996 forum... You should go to the advanced search and type in:
antenn* AND wing....???
Finally!!!
You can't search on two letter words, unless I have them programmed in. The reason for that is that if the "search" indexes words of two letters - the search index/database grows out of proportion, especially in light of the number of posts archived. Right now - with selected three letter words and all 4+ letter words indexed, the "word" database contains tens of millions words pointing to the nearly 2,000,000 posts...
Make sense??
Best to you - and hang in there!!!!
John
Also - what browser are you using - as I'd like to recreate what you are seeing..???
A few comment - the AND, OR, NOT (depending on what you are looking for) in the phrase structure should be capitals (but, it really shouldn't matter - but...
![Wink](https://rennlist.com/forums/images/smilies/wink.gif)
transmission AND oil should be the same as transmission and oil As well - the wildcard "*" can be used as a prefix or a suffix - or both! So... *miss* should bring up "transmission" while "miss*" would bring up mission...
So - let's say you were looking for just "wing antennas" in the 996 forum... You should go to the advanced search and type in:
antenn* AND wing....???
Finally!!!
![Smilie](https://rennlist.com/forums/images/smilies/smile.gif)
Make sense??
Best to you - and hang in there!!!!
John
#10
Banned
![Default](https://rennlist.com/forums/images/icons/icon1.gif)
OK - just tried it with IE v6.0.2X and using:
transmission AND oil
And here is what it returns:
Search: Key Word(s): transmission, oil ; Forum: 911 Forum and child forums
Showing results 1 to 20 of 65
Search took 11.80 seconds.
Hmmm - I'm wondering if you have a default "search" set in your cookies somewhere? At the bottom of the search form - you'll see a drop down box saying:
Save Search Preferences with a "Go" button. Using that drop down - select the Clear Search Preferences and click the "Go" button.... Let me know if that works, OK????
Best to you!
John D.
transmission AND oil
And here is what it returns:
Search: Key Word(s): transmission, oil ; Forum: 911 Forum and child forums
Showing results 1 to 20 of 65
Search took 11.80 seconds.
Hmmm - I'm wondering if you have a default "search" set in your cookies somewhere? At the bottom of the search form - you'll see a drop down box saying:
Save Search Preferences with a "Go" button. Using that drop down - select the Clear Search Preferences and click the "Go" button.... Let me know if that works, OK????
Best to you!
John D.
#11
Rennlist Member
Thread Starter
![Default](https://rennlist.com/forums/images/icons/icon1.gif)
John, it works! As I noted in the message above:
The problem was that the sort choice of relevence causes all searches to be conjunctive. Thanks, and I'm good.
Originally Posted by Phokaioglaukos
I sorted the results by relevence, BUT when I change the sort to last posting date it works and I get the 65 hits you noted.
#13
![Default](https://rennlist.com/forums/images/icons/icon1.gif)
John,
I tried your example (w/o quotes) "transmission AND oil" on the 911 forum and it return results, but (again w/o quotes) "good AND porsche AND book" or "porsche AND book" on the same 911 forum returned an error (... page unavailable ...). Any idea what might be amiss? Say you didn't include any "compiler optimizations" to cache the results of "transmission AND oil"?![Wink](https://rennlist.com/forums/images/smilies/wink.gif)
Oh, and I did do a "Clear Search Preferences | GO" before searching. I am using IE 6.0.X
I tried your example (w/o quotes) "transmission AND oil" on the 911 forum and it return results, but (again w/o quotes) "good AND porsche AND book" or "porsche AND book" on the same 911 forum returned an error (... page unavailable ...). Any idea what might be amiss? Say you didn't include any "compiler optimizations" to cache the results of "transmission AND oil"?
![Wink](https://rennlist.com/forums/images/smilies/wink.gif)
Oh, and I did do a "Clear Search Preferences | GO" before searching. I am using IE 6.0.X
#14
![Default](https://rennlist.com/forums/images/icons/icon1.gif)
John,
I might be waaay out in the weeds here, but it almost feels like I am getting a time-out on a query against a db.
How is the conjunctive search structured?
My layperson approach would be:
* suppose your index table (index_table) has 2 columns: 1 for the keyword, 2 for the id of the thread where it appears.
* the to find all threads that have the keywords "good" AND "porsche" you could do the below
* is it possible that the index on the index table has become fragmented and this is causing the query to time out?
select t1.*
from [index_table] t1
inner join [index_table] t2
on t1.thread_id = t2.thread_id
where t1.keyword = "good"
and t2.keyword = "porsche"
I might be waaay out in the weeds here, but it almost feels like I am getting a time-out on a query against a db.
How is the conjunctive search structured?
My layperson approach would be:
* suppose your index table (index_table) has 2 columns: 1 for the keyword, 2 for the id of the thread where it appears.
* the to find all threads that have the keywords "good" AND "porsche" you could do the below
* is it possible that the index on the index table has become fragmented and this is causing the query to time out?
select t1.*
from [index_table] t1
inner join [index_table] t2
on t1.thread_id = t2.thread_id
where t1.keyword = "good"
and t2.keyword = "porsche"
#15
Unaffiliated
![Default](https://rennlist.com/forums/images/icons/icon1.gif)
What the heck are "Child Forums", anyway? (other than the obvious OT!)