Consider this scenario, my database table has 300000 rows and has a fulltext index. Whenever a search is done it locks the database and doesn't allow anyone else to login to the portal. Any advice on how to get things sorted out here will be really appreciable. ...
Hello, I am trying to search my db for a string. But it should be able to match any word and not the whole phrase. Suppose table data has text like "a b c d e f g". Then if I search for "d c b" it should be able to show the results. field LIKE '%d c b%' does not work like that Can someone suggest a more robust way to search, possible...
We have a sql 2000 db that has some replicated tables (from another server) We're using full text indexing Sometimes, network connectivity stops replication, requiring us to restart it, which isn't a problem- however, this seems to remove the replicated tables from the full text catalogs, which causes problems Any ideas how i can fix t...
Hi I would like to know if it's possible to use "windows desktop search - 4" to Search pdf's and return pages/page numbers in that pdf's. ...
I don't know what they use in normal windows searching.But there is a technique in which you use indexing of files at once and then use the index later for faster searching.(e.g. Windows search 4.0) Is there any other way for faster searching than this? Can you elaborate from implementation point of view? (Assuming that I may need to im...
I have a typical enterprise/business application that I am developing that includes orders, salespersons, contacts, reference data, etc... There will be at least 100 or more users on the system at a time who are entering new data, changing data, etc. I need to provide search capability across the application for almost all tables. O...
Greetings, I'm thinking about the best way to implement a search on my website. I know about Sphinx and MySQL Full-text searches, however I'm not just searching a single field. I have two things that I want to search: the title of an article and the tags associated with that article. What I was thinking of doing is defining another col...
Hi Friends, I want to develop google desktop search like application, I want to know that which Indexing Techniques/ Algorithms I should use so I can get very fast data retrival. Thanks, Sunny. ...
I've got two SQL Server tables authors, and articles where authors primary key (AuthorID) is a foreign key in the articles table to represent a simple one-to-many relationship between authors and articles table. Now here's the problem, I need to issue a full text search on the authors table based on the first name, last name, and biograp...
I'm trying to implement a search feature for an offline-accessible StackOverflow, and I'm noticing some problems with using MySQLs FULLTEXT indexing. Specifically, by default FULLTEXT indexing is restricted to words between 4 and 84 characters long. Terms such as "PHP" or "SQL" would not meet the minimum length and searching for those t...
I have a LINQ-2-Entity query builder, nesting different kinds of Where clauses depending on a fairly complex search form. Works great so far. Now I need to use a SQL Server fulltext search index in some of my queries. Is there any chance to add the search term directly to the LINQ query, and have the score available as a selectable prop...
I've got the following query that uses a full-text index to search for the TOP 5 products (from the RawProducts table) matching the query, in a given Shop (populated by the @ShopId variable). At the moment I'm calling this procedure over and over again for every ShopId (there are 27 Shops) - which is a bit slow. My question is - could ...
Hi, i'm indexing strings containing URL's in MySQL Fulltext... but i dont want the urls included in the results. As an example i search for "PHP" or "HTML" and i get records like "Ibiza Angels Massage Company see funandfrolicks.php"... a hedonistic distraction at best. I can't see examples of adding regular expressions to the stop word...
I have the following query, which performs a full-text search (CONTAINSTABLE) on the Products table, and returns 1 record. Each Product is referenced by the ShopProducts table (each ShopProduct represents a product in a shop and is has a foreign key to Products.ProductId. Each row in the ShopProducts table has a ShopId column. My quest...
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, but apparently it has no priority. I'm stick to this CMS, the customer is awaiting m...
Any recommendations for small, lightweight, bag of words search engine? I have a set of 'documents' that are each basically a small bag of arbitrary words. Given a new document, I need to get a list of 'similar' documents along with some weight for how similar they might be. Documents are likely to be small.. a couple paragraphs at mos...
Where can I find an article to introduce the architecture of the LXR? I am very curious about it. How are the indexing and query served? Thanks, ...
I have a couple specific needs for my search and I'm interested to get people's opinions on what search approach makes the most sense. Based on my explanation below, would you recommend that I use basic sql queries? Or step up to a more advanced search solution, like Sphinx? I have two models that I want to search in: products and v...
Using mysql and PHP I am using MATCH AGAINST clauses already. It is working fine against individual tables. Like if i want to search in shops table. No problem. What i want is to be able to search and DISPLAY results from different tables in a single result page. Eg if i type "chocolate clothes" i may get 4 results as follows: Sho...
I use Djapian to search for object by keywords, but I want to be able to filter results. It would be nice to use Django's QuerySet API for this, for example: if query.strip(): results = Model.indexer.search(query).prefetch() else: results = Model.objects.all() results = results.filter(somefield__lt=somevalue) return results Bu...