|
1.How much more efficient is sphinx doing in searching fulltext than by attribute?
If attribute search is much slower,for better performance,I'm gonna prefix the attribute
and append to fulltext search.
But when it requires range search,only attribute...
Started by Shore on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
2) http://www.sphinxsearch.com/docs/current.html#api-func-setfilterrange
see http://www.sphinxsearch.com/forum/view.html?id=2908
for highly selective filter : fake keyword (1/1... .
Why not just test it out? I've never had a problem with it either way .
|
|
I'm using Sql Server 2008 FullText Search for a project. I need to be able to search PDf files, and I had some questions relating to that:
How do I enable PDF searching? I've heard of the adobe filter, but couldn't find a clear guide on how to get started...
Started by Swami on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
I haven't found a way to do this other than opening the file ... .
Fulltext is extensible Full Text Search" if the PDF files are stored within the database.
It will not index content outside the database.
Only search database content.
|
|
Hello,
I've got a search box that users can type terms into. I have a table setup with fulltext searching on a string column. Lets say a user types this: "word, office, microsoft" and clicks "search".
Is this the best way to deal with multiple search ...
Started by Paulj on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
With your DB, it might be feasible for you to pass the entire un-split search term into a SPROC the search terms based on delimiter, and then make a call on each, joining the results together.
|
Ask your Facebook Friends
|
Hi!
I have to hack a content management system to support fulltext search for a language that contains special characters. These are stored in the database as html entities. Out of the box, the CMS doesn't support it. The bug was reported long time ago...
Started by craesh on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Unfortunately won't work - http://bugs.mysql.com/bug.php?id=26265 just for search purpose with all accents....
Otherwise try to quote your search string once again like ('"search"').
Why you're using html entities? Just switch to utf8.
|
|
I've been experimenting with fulltext search lately and am curious about the meaning of the Score value. For example I have the following query:
SELECT table. * , MATCH ( col1, col2, col3 ) AGAINST ( '+(Term1) +(Term1)' ) AS Score FROM table WHERE MATCH...
Started by Eric Lamb on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Very simplified, it figures.
The formula normally used is based on the Vector Space Model of searching.
Generally relevance is based on how many matches each row has to the words given to the search.
|
|
I am working on search functionality in my website. I want to provide a best search mechanism to users. I am using PHP/MYSQL.
Let's say user searched for "sport".
I have 30 records having word "sport" and 5 records having word "sports" but when I am searching...
Started by Prashant on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Also all search strings must be greater then 3 characters in order ....
Sadly you will need to be in Boolean mode for this wildcard to work .
This will allow any words formed by the search string to be matched.
On your search strings.
|
|
Hi All,
I have what I think is a very basic scenario, but what I've read makes it sound like this is not easy in SQL Server Fulltext.
I have 2 columns, First and Last name. I want to support fulltext search on them such that if someone types "John Smith...
Started by tlianza on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
As far as I'm aware() function to apply a weight to each keyword... .
Make a computed column which mushes together the fields that you're interested in searching on (in a way that makes sense for your search formats), and full-text index that.
|
|
On Wed, 31 Mar 2010 16:52:32 +0100, Tompkins Neil <neil.tompkins@googlemail.com
Hi
I have the following fulltext search which appears to work fine for string
phrases. However if I search like just "51" which is part of the string
name like 51 ...
Started by Tompkins Neil on
, 4 posts
by 2 people.
Answer Snippets (Read the full thread at omgili):
See
http://dev.mysql.com/doc/refman/5.0/en/fulltext-fine-tuning.html for
more information on how to change.
The default minimum word length is four characters.
And therefore is returned
by a search.
|
|
I would like to use the search function inside a pdf document on the M92. However, it seems to search only the page I am currently on. Is there a way of searching a whole (pdf) document at once?
Started by Valec on
, 1 posts
by 1 people.
Answer Snippets (Read the full thread at mobileread):
|
|
On Mon, 31 Aug 2009 19:41:19 +0200, Merlin Morgenstern <merlin_x@fastmail.fm
Hello there,
I am experiencing problems with a search query that is using full text
search. Somehow the @ sign seems to be a wildcard.
For example a search for bla@gmail...
Started by Merlin Morgenstern on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at omgili):
Guess what.
Words are made up of letters, separated by word delimiters .
, 18:41, Merlin Morgenstern <merli...@fastmail.fm
I had always understood that fulltext was all about searching for
words.
|
