Stack Overflow
Stack Overflow

Questions tagged [full-text-indexing]

indexing for full-text search

569 questions
4
votes
1 answer

Full text search in Neo4j vs Elasticsearch

Both Neo4j 4.0 and elasticsearch have full text seach and inverted index with apache lucene. So how elastic search is better than neo4j full text search? Consider that we are dealing with the knowledge graph as a data storage model developed in…
Chaand Chopra
  • 43
  • 5
4
votes
1 answer

Laravel Scout v.s. MySQL Full Text Index?

I'm pretty new to Laravel and I've already got a light Laravel app running in production. Now I have to implement a full-text search (e.g. search content in all posts), I came across these options: Laravel Scout MySQL Full-Text Index 1+2 => Laravel…
Richard Fu
  • 616
  • 10
  • 27
4
votes
1 answer

Does dropping of non clustered index removes existing Full Text Indexing in SQL Server table?

CREATE TABLE [dbo].[TicketTasks] ( [TicketTaskId] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL, [TicketTaskTypeId] [char](2) NOT NULL, [TicketId] [int] NOT NULL, [CreatedUtc] [datetime] NOT NULL, …
manu vijay
  • 367
  • 3
  • 13
4
votes
1 answer

SQL Server ContainsTable not returning result with word that start with "N"

I want to make a query to retrieve people with NEAR syntax. When I search whatever text that contains letter N in second word, the result is always empty. I have two people Ricardo registred on table, "Ricardo Mova" and "Ricardo Nova". If a search…
Fábio Rabelo
  • 51
  • 5
4
votes
1 answer

Forgot to close the Lucene IndexWriter after adding Documents to the index

I had a program running for 2 days to build a Lucene index for around 160 million text files, and after the program ended, I tried searching the index and found the index was not correctly built, indexReader.numDocs() returned 0. I checked the index…
neevek
  • 11,760
  • 8
  • 55
  • 73
4
votes
0 answers

Mongo text index, search array of string elements

I would like to create a text index in my MongoDB which allows users to search a field that is an array of string elements. For example, my document looks like { "stringfield": "hello", "arrayfield": ["one", "two", "three"] } and I want…
mareoraft
  • 3,474
  • 4
  • 26
  • 62
4
votes
1 answer

How much extra storage does MySQL fulltext index consume?

I am looking for a way to estimate how much extra storage will be needed if a MySQL TEXT column gets a fulltext index. Intuitively speaking the size of the fulltext index is dependent on the total length of text but what exactly is affecting it?
Saul
  • 17,973
  • 8
  • 64
  • 88
4
votes
3 answers

Slow MySQL full text search

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…
Mihnea
  • 90
  • 1
  • 8
4
votes
0 answers

How to create Full Text Index via Hibernate Mapping

I can create Unique Constraint on a column in Hibernate mapping by @Table(name = "table_name", uniqueConstraints = { @UniqueConstraint(columnNames = {"column_with_unique_value"}) }) If I want to add Index to a specified…
The Coder
  • 2,562
  • 5
  • 33
  • 62
4
votes
1 answer

Sample Database for Full Text Searching

I am looking to do some benchmarking on Full Text Search indexes in PostgreSQL, SQLServer and Lucene. Any ideas on where to find a good big sample database to perform queries against? Thanks a lot in advance.
Pablo Santa Cruz
  • 176,835
  • 32
  • 241
  • 292
4
votes
1 answer

SQL Server 2012 - Fulltext search on top of a filetable - PDF not being searched

I'm getting my feet wet with handling a load of Office and PDF documents with SQL Server 2012's FILETABLE feature, and using fulltext search on top of that. I've configured my SQL Server to support fulltext search and filestream, and I've created a…
marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
4
votes
1 answer

apache cassandra query/full text search

I've been playing around with apache's cassandra project. Done a fair bit of readin and i have some fairly complex examples that i've done, including inserting single and batch sets of data, retrieving a single and multiple data sets based on keys.…
zcourts
  • 4,863
  • 6
  • 49
  • 74
4
votes
0 answers

non-transaction SQL Migration via Flyway

im trying to create Full Text Catalogs in SQL and migrating all the scripts via Flyway but im getting an error when I try to migrate Full Text Catalogs. Migration V1_5__FullTextSearch.sql failed ------------------------------- SQL State :…
Luis Arturo Cabello Rangel
  • 53
  • 1
  • 7
4
votes
0 answers

is it possible to index html content in postgresql full text search?

I have a bunch of html pages. The idea is to allow users enter keywords to search through these html pages. only html pages that match the criteria will be store for later references. I knew that Elastic search can index html,pdf, and more but in my…
channa ly
  • 9,479
  • 14
  • 53
  • 86
4
votes
1 answer

MongoDB - Logical OR when searching for words and phrases using full text search

I asked a related question previously, and as suggested by the poster there have created this new question as a follow up: MongoDB full text search - matching words and exact phrases I was having some problems with unexpected results when using the…
robarthur1
  • 457
  • 2
  • 9
  • 19
1 2 3
…
37 38