indexing for full-text search
Questions tagged [full-text-indexing]
569 questions
3
votes
1 answer
MySQL fulltext index query does not use any index?
I have a simple table created like this
CREATE TABLE IF NOT EXISTS metadata (
id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
title varchar(500),
category varchar(50),
uuid varchar(20),
FULLTEXT(title, category)
)…
daisy
- 22,498
- 29
- 129
- 265
3
votes
1 answer
C# NEST Elasticsearch custom filter structure (tokenize)
I am trying to rewrite this specific query to C# NEST, but Im stuck on defining filters... Im confused...
{
"settings":{
"analysis":{
"filter":{
"lemmagen_filter_sk":{
"type":"lemmagen",
…
lagugula
- 63
- 8
3
votes
1 answer
Text search whitespace escape
I'm using nodeJs Mongoose to perform text search;
var mongoose = require('mongoose');
var config = require('../config');
var mongoosePaginate = require('mongoose-paginate');
var poiSchema = mongoose.Schema({
city:String,
cap:String,
…
Jayyrus
- 12,961
- 41
- 132
- 214
3
votes
1 answer
How disable base64 storing for ingest-attachment elasticsearch plugin?
The documentation shows example about how store base64 documents into elasticsearch via ingest-attachment plugin. But after this I got that elasticsearch index contains parsed text and base64 field source. Why does it needed? Is there a way to…
Cherry
- 31,309
- 66
- 224
- 364
3
votes
1 answer
Mongoosejs text index an object
currently im having a problem regarding referencing text index in object
here's the code
Schema
var UserSchema = new mongoose.Schema({
username: String,
fullname: String,
email: {
type: String,
lowercase: true,
…
John
- 470
- 9
- 23
3
votes
2 answers
Algolia Geo Search Not Working
I am having some trouble with Algolia's geo search feature which was working properly before. Here is the record of interest.
I also had that indexed as described by the doc in order for me to sort it by the nearest distance:
'attributesToIndex' =>…
Aldee
- 4,439
- 10
- 48
- 71
3
votes
1 answer
How can I improve Lucene.net indexing speed
I am using lucene.net to index my pdf files. It takes about 40 minutes to index 15000 pdfs and indexing time increase with number of pdf file increase in my folder.
how can I improve indexing speed in lucene.net?
Is there any other indexing…
Munavvar
- 802
- 1
- 11
- 33
3
votes
2 answers
$and operator on multiple $text search in mongo
Is it possible to have $and operator on multiple $text index search in mongo?
I have documents in tp collection of my db
> db.tp.find()
{ "_id" : ObjectId("...."), "name" : "tp", "dict" : { "item1" : "random", "item2" : "some" } }
{ "_id" :…
Rohanil
- 1,717
- 5
- 22
- 47
3
votes
0 answers
Is there a way to get informed when SQL Server updates a full text index
I have a full text index on my SQL Server table with option CHANGE_TRACKING AUTO.
I can access the keywords and document IDs using the convenient sys.dm_fts_index_keywords_by_document system view.
My question is that can I get informed when a…
Samet Sevilen
- 81
- 1
3
votes
1 answer
Hibernate full text search custom order by
We want to add custom order by to hibernate full text search,suppose we want to search the record based on location, if the location is "country,state,city
Then we want to have the search with records in the top which are near to user
We followed…
Mohsin
- 469
- 5
- 13
3
votes
0 answers
Sql Server Containstable for searching within keywords
Scenario
I've stored some keywords about each product in a column with name Tags .When a user searches a word that exists in this column, a relevant product must be shown. The user may enter some general words in the search query(for example:…
Micle
- 159
- 10
3
votes
1 answer
SQL Server: one table fulltext index vs multiple table fulltext index
I have a search procedure which has to search in five tables for the same string. I wonder which is better regarding read performance?
To have all tables combined in one table, then add a full text index on it
To create full text indexes in all…
rahebirizah
- 115
- 11
3
votes
1 answer
List words indexed by Innodb fulltext
In Mysql (Innodb) I have created a FULL-TEXT index.
Is there a query I can use to retrieve a list of all words contained in the full-text index?
My idea is to use a text field that hold a json dump of a list of TAGS.
Than I can use full-text query…
Fabiano Taioli
- 5,270
- 1
- 35
- 49
3
votes
1 answer
In SQL Server How to create full text index with TYPE COLUMN option
I have a table definition as below
CREATE TABLE [dbo].[Dialogs](
[ID] [int] IDENTITY(1,1) NOT NULL,
[DiscussionID] [int] NOT NULL,
[ApprovedByUserID] [int] NULL,
[AddedByUserID] [int] NULL,
[Text] [nvarchar](max) NULL,
…
Arjun Vachhani
- 1,761
- 3
- 21
- 44
3
votes
2 answers
Using lucene to search data differently for different users conditionally
Consider that the entities that I need to perform text search are as following
Sample{
int ID, //Unique ID
string Name,//Searchable field
string Description //Searchable field
}
Now, I have several such entities which are commonly…
labyrinth
- 1,104
- 3
- 11
- 32