Questions tagged [full-text-indexing]

indexing for full-text search

569 questions
0
votes
2 answers

Full text catalog population always in progress, never actually populated

I have created a full text index on my dev server on a view that returns few rows. The population schedule is currently set to run once a day. However the full text index is returning no results as though it is not populated. If I run SELECT…
cbp
  • 25,252
  • 29
  • 125
  • 205
0
votes
1 answer

search engine ideas for description of results

I am making a search engine for full text search, and i have a problem in performance when displaying results with description. I made the results for the current query, but the lack of performance is when i try to get the text and highlight the…
badc0re
  • 3,333
  • 6
  • 30
  • 46
0
votes
2 answers

Postgresql - full-text ordering of sorted out set

I have a Postgresql table with something like 200k tuples, so not that much. What I try to do is filter out some rows and then order them using full-text matching: SELECT * FROM descriptions as d WHERE d.category_id = ? AND d.description != ''…
Lubiluk
  • 704
  • 5
  • 12
0
votes
1 answer

Column that matches in a fulltext index spanning multiple columns

I am using the latest version of MySQL 5.5. I have a fulltext index spanning multiple columns in a table generated specifically for fulltext search (other tables in the database uses innodb): somedata_search ======== id name about note dislike I…
F21
  • 32,163
  • 26
  • 99
  • 170
-1
votes
1 answer

User search multiple values with sql like query

Using PHP and Databases, I have a simple search query statement : SELECT * FROM products WHERE LOWER(product_title) LIKE '%$search%'; E.g product title: 'Red Apples Tree' e.g search 1: ' red apples outputs the title successfully e.g search…
-1
votes
1 answer

Fulltext index with ids from another table

I have a product table where the rows are connected to one or multiple rows in a category table by category_id. If I would like to make those category names searchable, is there any solution to specify the fulltext index to be created of the names…
Joseph
  • 1,734
  • 6
  • 29
  • 51
-1
votes
1 answer

How to Append Dash to Existing String?

For a homework problem, one of my functions requires a dash to be added at a certain index. For instance, with a sequence such as "ABC" - at index 2 of a new string (as per Python rules) - the string would ideally output "AB-C." So, index 2 of a…
-1
votes
1 answer

DB2/400 SQL : FullText

SQL DB2/400 : Is there somebody has tried to work wth FullText. If i can have a sql exemple code, it will be great . I would like, for exemple, to use it with a clob column. Many thanks
-1
votes
2 answers

How do I search for ALL words within ANY columns of multiple Full Text indexes?

If I have two full text indexes on tables such as Contacts and Companies, how can I write a query that ensures ALL the words of the search phrase exist within either of the two indexes? For example, if I'm searching for contacts where all the…
-1
votes
1 answer

Database search using a support table for FULLTEXT search

I am implementing a search function for a REST API and it is my first time dealing with large database searches. My MySQL Location table has the following columns | id | name | email | phone | postcode | address | verified | A user can search for a…
-1
votes
1 answer

Azure SQL Full Text Index initial population slow

I have a table with approximately 4.7 million records. I created a full text index on it. I am experiencing slow initial population of the full text index. Initial pricing tier that i had was S1, I upgraded it to S3 but i did not get better…
-1
votes
1 answer

To Bring the exact match at very top from Search Results (Apache Solr 5.5)

I have a field "description" and I am searching a text against this filed having default Similarity scoring. Say, i have searched for "hello man" and i am getting results like "hello mango", "hello man how you", "hello man10", "hello man", "hello…
-1
votes
2 answers

Why is "or not" and "not" not allowed in Contains (tsql)?

I have searched if there is a reason why tsql contains wouldnt allow "or not" or "not" as unary operator. On the microsoft site it just says "OR NOT operator is not allowed" CONTAINS (Transact-SQL) I can simply put the unary not in outside of…
-2
votes
1 answer

solr indexing not working when i try to insert 1000000 rows but works fine when i try to index 400000 rows or below

iam using solr 4.7.1 and trying to do a full import.My data source is a table in mysql. It has 10000000 rows and 20 columns. Whenever iam trying to do a full import solr stops responding. But when i try to do a import of 400000 or less it works…
user3576187
  • 81
  • 1
  • 7
1 2 3
37
38