8,007 questions
-2
votes
0
answers
31
views
Is it good practice to index a large text column (up to 800KB) for full-text search in PostgreSQL? [closed]
I'm working on a PostgreSQL database for a blogging platform, and one of the columns in my table, blog_content, can hold text up to 800KB per row. This column stores the main content of blog posts, ...
- 107
0
votes
0
answers
31
views
SELECT * FROM my_table where match('ZS'); not worked in manticore
I have install manticore successfully.and my manticore config file is:
source my_source{
type = mysql
sql_host = 127.0.0.1
sql_user = test
sql_pass = iflytek
...
- 1
-3
votes
0
answers
30
views
Issue with Using Regex on Redis FT.SEARCH Results in Grafana
I am new to Redis and am currently working on a project where we store sensor data in Redis. We use the FT.SEARCH command to retrieve sensor details. Among the retrieved details, I am particularly ...
1
vote
0
answers
10
views
How to use TextIndexed with subDocument (MongoDB & Java)
I have a document with name User and this document has subDocument with name UserIdentifier like below:
@Data
@Document
public class User {
private List<UserIdentifier> userIdentifierList;
...
-2
votes
2
answers
53
views
Why mysql fulltext-search so slowly?
The table xx_user_detail, user_id is int primary index, site1-site9 is combined fulltext index, the total row count is 5 million
SELECT * FROM xx_user_detail WHERE (user_id=14) AND MATCH (site1,site2,...
- 141
0
votes
1
answer
44
views
How to handle alphanumeric combinations (like "Hotel101") in Elasticsearch query results with multi_match?
I am working with Elasticsearch and I have an index that contains entries with alphanumeric combinations like "Hotel101 fort". When I search using a query like "Hotel 101 fort", I ...
0
votes
0
answers
115
views
MySQL query to do FULL TEXT INDEXING and similar sound words
I have a table as shown below. A user can search this table on the basis of Interests. For example, user can search “Carl to”. Then it should return the first 2 emails, because we have 2 similar ...
- 782
0
votes
1
answer
98
views
Qdrant: create index on payload text field
I am using Qdrant to store vectors and payload. For example, my documents are like:
{ "id": 1234,
"title": "my_title",
"description": "my_description&...
- 742
0
votes
0
answers
43
views
how to fix VS Code search working inappropriate
In VScode am trying to search in all files and replace the copyright year from 2023 to 2025 but the search is not finding correct characters. And so the replace is not working as intended. instead ...
- 43
0
votes
0
answers
60
views
Apache Lucene indexing strategy to handle large dataset on windows in desktop environment
I do have data divided into 60 sqlite database files. Each database represent a city. Number of rows is different in each database but schema is exactly same with total number of fields are 12. Out of ...
- 913
2
votes
0
answers
121
views
The value of citation entity field 'citation.appearance.abstract' exceeds the length limit. The maximum length is '480' characters
I have a problem integrating Azure OpenAI with Microsoft Teams through the Teams toolkit. The response generated by the API exceeds the character limit allowed in Teams, which causes constant errors ...
0
votes
0
answers
48
views
two word param search
my instance's name is "hello world",just imagine in an urgent situation, i am going to search with param as "helloworld". how to handle without space cases
if q:
normalized_q ...
0
votes
0
answers
38
views
MySQL fulltext MATCH AGAINST IN BOOLEAN MODE query using a LEFT OUTER JOIN table's column unexpectedly returns no results [duplicate]
In MySQL 5.6.51 using InnoDB, I have two tables:
users
user_aka_names
Table details:
user_aka_names has a foreign key, user_id to users
One user can have many user_aka_names
Not all users have a ...
- 11
0
votes
0
answers
38
views
FULLTEXT searching for spaces, full stops
I am experimenting with FULLTEXT searching, using the InnoDB storage engine. I am upgrading from MYISAM to InnoDB and I have noticed that a lot of queries containing LIKE clauses, which were fast ...
- 812
0
votes
0
answers
34
views
script for AutoHotKey v2 that is searching for a file in all drives
i want a script for AHK v2 that is searching for a file in all drives named "autorun.inf" that contains the line "label=jhon" and if the script found the file to search only in the ...
0
votes
1
answer
88
views
MySQL full-text search with aggregate functions
I have a website connected to a MySQL database of songs, and am working to improve full-text search on the site. A simple query with MATCH() works as expected, but as soon as I add an aggregate ...
- 254
0
votes
0
answers
20
views
read Windows Indexing Service settings from script
Windows indexing service could be configured to indexing file names only (default), or file names AND file content. Need detect this option setting by script. Investigating "Windows search" ...
- 1,340
0
votes
1
answer
53
views
MariaDB fulltext index tokenization rules / DOC_ID mapping
First question: is there a document that describes the rules how MariaDB builds the fulltext index words (for InnoDB)?
I set innodb_ft_min_token_size=1 to include also one letter words in the index. ...
- 400
0
votes
0
answers
77
views
Prisma raw query integration with PostgreSQL full-text search: ts_rank and to_tsquery not working
I'm working with a PostgreSQL database, and I'm trying to convert a complex SQL query using Prisma's queryRaw. The query works fine using pg and pool.query, but when I attempt to use Prisma's $...
- 263
0
votes
0
answers
44
views
Would a fulltext index across multiple columns be better in this case?
Currently, the search query that I'm using for searching my forum looks like this (this particular search was for the term "6.18") (this is just part of the where clause that deals with ...
- 5,083
0
votes
1
answer
53
views
How do traditional search engines like Lucene handle tokenization and indexing, and why don't they use integer mappings for tokens?
I've been learning about how traditional search engines like Lucene work, and I understand that they typically build an inverted index by tokenizing the text in the corpus. These tokens are then used ...
- 9
0
votes
1
answer
70
views
To restrict vim the search to a specific part of the text
How do we restrict the search to a specific part of the text referred in basic row-coiumn positioning mainly (and visual selection, an extra way, if one would give) on (neo)vim just like substitution
:...
- 1,297
0
votes
1
answer
79
views
Using CONTAINS with SQLAlchemy on Azure SQL in python
I am trying to use a full text search using CONTAINS or FREETEXT function.
I am using Azure SQL with SQLAlchemy using the mssql and aioodbc drivers.
I have a table with 3 TEXT columns which I'd like ...
user26953316
0
votes
0
answers
20
views
Fulltext search of MS Office files in SQL Server AWS RDS
I'm aware of the filter packs that can be installed at the OS level for a standalone SQL Server instance to gain support fulltext searching of MS Office and PDF files, but is there any way to get ...
- 1,210
0
votes
1
answer
32
views
Searching for specific string in a folder system
So I have a folder system in Windows with a bunch of files with php. I am trying to find all the times a specific string/variable is used in the files but I dont want to go through each file and CTR-F ...
1
vote
1
answer
42
views
Mongo Atlas Search find by one of two fields
I have a documents in collections like:
{
_id:"....",
resourceId: "375749d7-a828-4a7b-acc0-77539fbcb7b4" // string type
name: "bla random word"
}
with index:
{
"...
- 134
-1
votes
1
answer
32
views
MySQL Full-Text search uncontrolled sort
MySQL 8.0.34
The following full-text search query didn't sort data according to relevance, please advise how I can control sorting on relevance. (script to create the table, insert data is in the ...
- 167
0
votes
0
answers
54
views
DocumentDB Text Index Search Not Matching Phrase with Delimiter
I have a collection in DocumentDB 5.0 that has a text index on several fields.
Some of those fields allow for periods to be part of the field value.
I am not getting results when searching the text ...
-1
votes
1
answer
24
views
Typesense, disabling the search Analytics for specific routes in Laravel
I'm using Laravel with typsesnse as the search driver for Scout,
I want a way to disable the search analytics for some routes for example in my case i want all the API routes to be excluded from the ...
0
votes
1
answer
91
views
Azure AI search handling special characters
I have created the following index in Azure AI search,
{
"name": "classic-index",
"defaultScoringProfile": "",
"fields": [
{
...
- 97
0
votes
1
answer
88
views
Lock in tantivy while searching
I am using an Actix server to support a total of 1000 transactions per second (TPS), with clients sending requests from 10 threads in parallel. Tantivy search queries from the index are typically ...
- 406
0
votes
1
answer
142
views
Best alternatives for a fast search on a big table on a Postgres database?
We have an Express API that connects to a Postgres database using Sequelize.
One of our endpoints returns a list of sales, which accepts different query parameters like page, column order, filters, ...
- 534
0
votes
1
answer
33
views
SphinxSearch ranking
I have 5 fields across 3 tables in my database and I am trying to use SphinxSearch to make a search in those fields. I am trying to achieve this - for example I have three words to make a search word1,...
- 1,318
0
votes
0
answers
64
views
What might cause this Fulltext query to be executed thousands of times. Re-enabling a Fulltext Index perhaps?
We had a complaint from a client today about the responsiveness of our application. When we looked into the Azure Query Performance Insight and the Performance Overview we noticed three queries being ...
- 550
0
votes
1
answer
49
views
How to make a gremlin fulltext search query when fine grained control is enabled in opensearch domain
How to query using gremlin when fine grained access control is enabled in opensearch domain?
g.withSideEffect("Neptune#fts.endpoint", "your-es-endpoint-URL")
.V()
.tail(100)...
- 3
0
votes
1
answer
90
views
Tomtom API search by street
The documentation is very light and there is not support offered.
So what I'm trying to achieve (or figure out if it's achievable), is to search by street name in a given country using Tomtom's search ...
- 141
1
vote
2
answers
163
views
How to Optimize Search Queries on a Large PostgreSQL Table without Compound Indexes?
I have a PostgreSQL table named users which contains between 20 to 30 million records. The table has the following columns: id, tenant_id, name, company, location, and description.
I need to perform ...
- 49
0
votes
0
answers
52
views
How to Optimize MongoDB Aggregation Pipeline with Keyword Search and Sorting for Large Dataset?
I am working on a Laravel project that uses MongoDB via MongoDB Atlas. I have a collection with millions of documents, and I am running a complex search query that includes keyword search, sorting, ...
- 11
0
votes
0
answers
57
views
What to use for text search for a niche e-commerce site using Postgres
I have this small/medium e-commerce site for a niche market. We have tens of thousands of products and are looking to implement of fully functional search bar (previously searched through guided flow/...
0
votes
1
answer
45
views
Is there a way to limit the long list of search results in my live javascript search bar so it responds faster on desktop browsers?
I have a javascript live search bar, it reads a .js file that holds the records. I added about 20,000 records to the original and an equal amount of corresponding links for those records. On my mobile ...
- 3
0
votes
0
answers
49
views
Full text search, not finding subitems
I have setup Microsoft SQL Server full text search on a few tables.
These tables contain numbers, like phone numbers.
If I do a contains search on the full number, it returns matches, but not on a ...
0
votes
0
answers
117
views
Is there an option on Typesense to allow unlimited documents?
I recently moved from meilisearch to typesense on my Laravel app working with scout.
I've done all my configuration of models and search queries.
I was using a local instance of typesense which ...
- 312
0
votes
0
answers
44
views
web aplication using php pdo fulltext search delivers result on ubuntu system but not on windows system; identical DB on both
The setting
Windows 11
Server-Version: 8.4.0 - MySQL Community Server - GPL
Apache/2.4.61 (Win64) PHP/8.3.8
Ubuntu
Server-Version: 10.3.39-MariaDB-0ubuntu0.20.04.2 - Ubuntu 20.04
Apache/2.4.41 (Ubuntu)...
- 399
1
vote
1
answer
143
views
Multicolumn seach vector with postgresql
In a postsgresql v13 database, I want to add a search vector on a table, and i want to put several columns (not all the same type) in that vector.
I have some 7 text columns, 1 json column and 1 jsonb ...
- 943
0
votes
0
answers
44
views
MongoDB aggregation pipeline: pagination is not working as expected with id cursor and text index
I'm making an aggregation query to my MongoDB using a text index, I implemented a pagination system but it's not working as expected
At first, I thought it was related to the other sort field, but it ...
- 206
0
votes
2
answers
92
views
Parse a search string into words and treat words within double quotes as a single term
I know that if I want to parse a string into separate words, the easiest way is.
This is my string:
The Microsoft business analysis software
Code:
SELECT special_term, display_term
FROM sys....
- 75
-1
votes
1
answer
66
views
SQLite slow combined query from two fast SELECT queries
Select join query with FTS table is slow if other WHERE conditions are specified. But these WHERE conditions without fts MATCH condition are not slow and fts MATCH is not slow alone. How to combine ...
- 71
0
votes
0
answers
44
views
How to create an Instant indexing plugin function for a core PHP website currently used in the WordPress platform?
WordPress platform is easy to use because of themes & plugins. Now, the Instant indexing plugin is very useful to submit newly added pages to Google Search indexing API.
Similar actions want to ...
0
votes
1
answer
84
views
Elasticsearch Query for Exact Substring Matching with Spaces
I'm trying to perform an exact substring match in Elasticsearch, including substrings that contain spaces. Here’s what I need:
Search for an exact substring within a larger text field.
The substring ...
- 53
0
votes
0
answers
29
views
How does standard text search work across languages, with respect to problems like vowels in Hebrew?
In Hebrew, the vowels (nikkud) are optional and, when included, are written around the main text. For example, the name Miriam is מרים without vowels or מִרְיָם with vowels (note the little dots and ...
- 3,247