I've built an ASP.NET MVC application with MVC 2.0 and Fluent NHibernate (hided behind repositories for some reasons). The application represents a quite complex domain with some different objects like users, messages, comments, files and appointments. Now I want to implement a fulltext search which is enabling the user to find easily a...
With Compass going the way of the dodo (or at least no longer being actively developed), I wonder what other technologies there are that fill a similar role. I'm aware of Hibernate Search, but nothing else really. It seems the direction things are going is towards full indexing agnostic of entities and relationships. Are there other tech...
Hi I'm trying to execute a search in SharePoint 2010 with the FullTextSqlQuery class: using (SPSite site = new SPSite("http://localhost")) { using (FullTextSqlQuery query = new FullTextSqlQuery(site)) { query.QueryText = "SELECT Title, FooText FROM scope() WHERE FooText = 'Foo2'"; query.ResultTypes = ResultType.RelevantResu...
Subquestioning "full-text search sql server 2005" Would the use of FTS (Full Text Search) be faster in comparison with searches using tsql LIKE on indexed column(s)? Why? And how much? ...
How to search text in some files like PDF, doc, docs or txt using PHP? I want to do similar function as Full Text Search in MySQL, but this time, I'm directly search through files, not database. The search will do searching in many files that located in a folder. Any suggestion, tips or solutions for this problem? I also noticed that, ...
I want to use the full-text index to search word: How can I use 'contain' or 'freetext' to get the same result as "like '%dd%' "? If I use contain(table,'data'), it only finds "....the data is ...." How can I use contain search 'dat' to find data? ...
Hi guys, I'm using this query to perform a full text search on a MySQL database: SELECT DISTINCT questions.id, questions.uniquecode, questions.spam, questions.questiondate, questions.userid, questions.description, users.login AS username, questions.questiontext, questions.totalvotes, MATCH(questions.questiontext, questions.uniquecode...
In a SQL Server database I've two tables: Job and JobKeyword. Each Job has JobKeywords. I'm trying to learn how to use Full Text Search. How can I get a list of all jobs in the databases, ordered by shared keywords between the search query and the jobs? ...
Hi! I'd like to get some ideas on how I can create an efficient MySQL database that can handle high traffic auto-complete requests like Google's new auto-SERP-update feature. The key to this is, I am trying to take the content of my book and I want to index the text in a way such that the database requests the relevant text in the qu...
I'm trying to add a full text search to a system. The query I want to write needs to involve multiple lookups followed by the search (if that's even possible). I've got a table of teachers and a table of subjects. teacherProfile teacherId [int] - primary key subjectOneId [int] subjectTwoId [int] subjectThreeId [int] teacherBiography [t...
How can i set maximum number of pages to index per host? i don't want to index all million pages of site, i want to index only first 100000 found pages. ...
Just getting started with Lucene.Net. I indexed 100,000 rows using standard analyzer, ran some test queries, and noticed plural queries don't return results if the original term was singular. I understand snowball analyzer adds stemming support, which sounds nice. However, I'm wondering if there are any drawbacks to gong with snowball...
My site (ASP.NET + C#) has FAQ data pull from another site's web service in XML format. The data size is pretty small (just about 50 faqs). I want to implement a keyword search for the FAQ and highlight the search keyword. What could be a fast and easy approach to do this? My first thought is just using a C# string search or any XML sea...
Hey, so I'm wondering if it's possible for Sphinx to weight certain fields of document over others in its results. For example, if I did a search for 'the rock show', is it possible to configure sphinx to give much higher precedence to a song named 'the rock show' over a song which has 'the rock show' in its lyrics? ...
Hi folks, I have the following sql query for a SQL Server 2008 db. SELECT TOP(@NumberOfStreetResults) LocationType, LocationId, Name FROM [dbo].[LocationNames] WHERE CONTAINS(Name, @SearchQuery) AND LocationType = 7 Notice how I'm using the CONTAINS keyword? I have an FTS on the Name field. I'm not sure what index(s) I need to ...
Hi there, I have search functionality in my app, in which when user clicks in textbox, the text in the text box disappers. This works perfectly in chrome(6.0) but does not disappear after click in mozilla firefox(3.6) why? // here is the code: echo "Search: "; echo "<input type=\"text\" class=\"smalltxt\" name= \"srcht...
I'm doing the following query SELECT * FROM downloads WHERE MATCH (title, artist) AGAINST ('+like ' IN BOOLEAN MODE) ...and it's not returning any results when it should be. It's not the code or anything, since it works fine for any other search terms. Could it be the fact that like is commonly used in MySQL queries so it's i...
I am trying out Sphinx search in my Django project. All setup done & it works but need some clarification from someone who has actually used this setup. In my Sphinx search while indexing, I have used 'name' as the field in my MySQL to be searchable & all other fields in sql_query to be as attributes (according to Sphinx lingo). So wh...
I use Sphinx to index HTML pages, giving different weights to title, description, etc. I'm looking for a way to get the search words location in the page from the results that I get from Sphinx. Meaning, if the wordset is "stack overflow program" and I have 5 documents that match, each of them was a match because it contained at l...
Hello, I have a Page model. The Page model consists mainly of just the page name, however the actual page content is made up by many page components using has_many_polymorphs. Each of these page components also has a name and the linked component may contain more data, such as date values, textual content, images or other files. This h...