indexing for full-text search
Questions tagged [full-text-indexing]
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…

mikey1091
- 9
- 2
-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…

person1337
- 1
- 1
-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

Jchristophe Cherid
- 67
- 10
-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…

adam0101
- 29,096
- 21
- 96
- 174
-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…

WiserTheBassist
- 49
- 1
- 6
-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…

Chiricescu Mihai
- 239
- 1
- 9
-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…

itzmesujikumar
- 13
- 5
-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…

Manuel Hägeli
- 13
- 4
-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