Alright so I've got a ListView with many items available to it any time (in virtualized mode). Right above the ListView is a text box that allows the user type in any search term and the ListView will be filtered live. The ListView is currently bound to a DataSet like this: SoundListView.DataContext = DS.Tables[0].DefaultView; The Dat...
I'm new to sunspot and rails 3, so I followed this little tuto: http://github.com/exempla/sunspot But there is not a lot of details, and the official github of outoftime/sunspot do not speak much about the rails 3 version. ex: How can I do a rake sunspot:reindex So if anyone know where I can find some good rdoc for the rails 3 versio...
How can I make plural/singular words pull all forms? Example: If a person searches for "mens rings" how can I check the data base to see if any of the fields contain mens, men, men's, ring, rings, etc.? ...
Are you aware of any lexical analyzer or lexer in Qt? I need it for parsing text files. ...
I am trying to get all users in a department from User Profiles using FullText Search. I have used the following query: SELECT AccountName FROM scope() WHERE ( ("SCOPE" = 'People') ) and (department = 'HR') I am getting empty result set for this. But, the following query returns results for all records which contains the text 'HR':...
I'm using SQLServer 2008 and if I perform the following query: SELECT * FROM FREETEXTTABLE(SomeTable, Name, 'a name that I know exists') I get the rows back that I would expect, but the rank is always 0. Searching for a solution to this problem, I found this question on the Microsoft ASP.NET forum, and sure enough if I add: ALT...
i use whoosh for full text search , and i want to know : how to get all 'index data ' that be added. this is my main.py import cgi,os from google.appengine.ext import webapp from google.appengine.ext.webapp import template from google.appengine.ext.webapp.util import run_wsgi_app from whoosh import store from whoosh.fields import Sc...
this is whoosh so ,did you know which is better ? thanks ...
How words break in the full text indexing process depends on what language you use, right? Now let's say I want to add a breaking character that usually is not, in any language. Example: I want words to break at the letter a how do I accomplish that? And let's also say I have a word that I want to act as a wordbreaker, for example th...
I have an asp.net web page used to search for company names in our database using FTS. They enter the company name in a search box and submit. First I trim any leading or trailing spaces, then i replace each internal space with " NEAR ". So a search for: "The Association of Lefthanded Picklepickers" Is fed as: "The NEAR Associ...
This query is running only for data available in t1.ads_category, not for the other two columns: SELECT t1.id, t1.ads_type, t1.ads_category, t1.ads_subcat, t1.ads_title, t1.ads_title, t1.ads_description, t1.ads_city, t1.ads_location, t2.ads_image, t2.ads_activate, ...
I have a 9-million-row table in a MySQL database that needs full-text search against three of its fields. We thought the hard part would be finding that one-in-9-million row, but that's not what we ran up against. Our problem is that one of them is a "location" field, so searches for "poughkeepsie" come back super-fast, but searches fo...
In Oracle, the full text search syntax of Contains operator is: CONTAINS( [schema.]column, text_query VARCHAR2 [,label NUMBER]) RETURN NUMBER; which means the text_query can not be more than 4000 characters long or an error will occur. I repeatedly have text_query longer than 4000 characters lon...
I need to find places I used a method in the historic context of my application. Anyone know how to do this? Thanks! paul ...
Is it possible to perform document similarity search efficiently using sphinx search? My index consists of 500k documents, each which is tagged by 5-30 different short, all lowercase stemmed words which is the data to search through. For simplicity, all tags in the database has equal weights and I'm not using phrase searching. My first a...
Hi I am planning to implement database search through a website - I know there is full-text search offered by mysql, but turns out that it is not supported for innodb engine (which I need for transaction support). Other options are using sphinx or similar indexing applications. However they require some re factoring of the database str...
I am trying to search for values with OR and AND here is a example for OR SELECT * FROM contacts_items WHERE MATCH (item_id) AGAINST ('(10 | 1)' IN BOOLEAN MODE); This works but if I wanted to do AND SELECT * FROM contacts_items WHERE MATCH (item_id) AGAINST ('(10 & 1)' IN BOOLEAN MODE); This will attempt to find contacts with 1...
Hi, Let's say I have the following string stored in a column which has full-text: xx 3 555 7 4 My question is why a search using FREETEXT for the word '555' would not return anything ...
I have 10,000,000 records which will be the best technique to search records, currently i m using full text search but it is slow,please suggest. ...
Imagine you have a web application written in Django and Python 2.65, and MySQL 5.1 is your database of choice. Now, imagine you will need to scale your app to handle searching 100's of thousands of document and potentially 100's of thousands of users will be using it. Reality: Haystack 1.0 with PySolr and Solr 1.4.0 is proving slow i...