34,561 questions
-2
votes
0
answers
24
views
How much time it takes to index text data QDrant using Open WebUI? [closed]
I use a non-default Vector database for indexing knowledge bases in Open Web UI, but for a text file of size 0.2GB, it is now been running for 5 hours: is that normal?
I run the application on my I9, ...
- 1
1
vote
0
answers
39
views
Search custom ckan resource metadata
I am exploring CKAN and was trying to store some custom fields while creating resources in CKAN using the resource_create API. After storing the resource I want to be able to search using the custom ...
- 11
2
votes
4
answers
89
views
Postgresql stops using filter index
I have a very simple table for a task queue and keep taking records out one by one. If I add the filter_selector after filling/resetting the table, postgresql will use it and run super fast. But if I ...
- 14.3k
0
votes
1
answer
49
views
MongoDB Atlas Search Index Too Slow
I need to search crypto tokens by name (text search), symbol (exact match) or address (prefix match, i.e. return all tokens the address of which starts with the user query). Instead of relying on a ...
- 618
1
vote
1
answer
84
views
How to improve word_similarity query performance in postgresql?
In a project, we are using postgresql v12.11 (updating is sadly not an option at the moment).
Consider the following relations:
document (
id uuid primary key
)
page (
id uuid primary key,
...
- 1,411
2
votes
1
answer
104
views
How to extract a value from a list without getting “length 0” errors? [duplicate]
I’m parsing some JSON data in R and got this structure:
entry <- list("Ontario"="ON", "ON"="13.6")
When I try:
j <- entry["Ontario"]
population ...
- 11
2
votes
2
answers
168
views
MySQL: Writing better compound indexes
I recently came to know about the performance boosting capabilities of using compound indexes or composite keys in mysql through this question of mine Create multi table index/composite key.
After ...
- 2,035
1
vote
1
answer
67
views
SQL - Adding Union All on derived table subquery fetches all rows
Attempting to optimize a portion of a query that is joining two related tables, and getting odd results compared to other queries in the project with similar structures. Here is a very simplified ...
- 11
2
votes
1
answer
55
views
Postgres not using index with varchar_pattern_ops for pattern matching query
I have a query in PostgresSQL accessing a big table using a LIKE clause for pattern matching:
Table "rmx_service_schema.document"
...
- 23
0
votes
1
answer
116
views
Query with WHERE clause on a UNION query results in a table scan without using the indexes
An MS Access query with a WHERE clause on a UNION query results in a table scan without using the indexes.
Example: There is a table like this:
CREATE TABLE tblFigures
(
EntryDate DATETIME,
...
- 63
0
votes
1
answer
82
views
MySQL 8 slow queries on indexed table with WHERE event = ? AND merchant = ? AND created_at >=?
I’m troubleshooting slow queries on MySQL 8 and need advice.
I have a table salla_events (~1M rows). The queries look like this:
SELECT *
FROM salla_events
WHERE event = 'order.created'
AND ...
- 11
2
votes
5
answers
155
views
Find match value VBA on 4 conditions
Can anybody help with this? look at the picture I upload.
I have 2 stores with the same location in column "A" and "G", column "B and I" says condition on location. And ...
- 47
2
votes
3
answers
102
views
MySQL index to use for range tests
I have this index:
create index main_cp_index on catalogue_product(
product_class_id, is_public,
(cast(coalesce(data->>'$."need_tags"', 0) as unsigned)) ASC);
When i'm trying to ...
- 273
0
votes
0
answers
48
views
Netbeans download the whole maven repository not the needed dependencies for a spring boot project
Please help, I want to start using netbeans for developing spring boot projects, but I struggle with how to download and use only the needed maven dependencies via netbeans, not downloading the whole ...
- 127
1
vote
0
answers
28
views
Cannot index const object by known property in TypeScript [duplicate]
I have a complex but well-typed constant object such that no matter what the first and second level keys are, there is always a particular known key at the third level (in the example below, moons). ...
- 2,534