2,610 questions
0
votes
1
answer
221
views
Inner join performance issue
I'm experiencing a performance issue with the following query, specifically caused by the join condition
AND edh.EmployeeCode = e.EmployeeCode
After analyzing the execution plan, I noticed that SQL ...
- 17
0
votes
0
answers
68
views
AWS RDS MariaDB query surprisingly slow on single value result
I have the following tables:
create table account_transactions
(
id int auto_increment primary key,
account_id int not null,
amount ...
- 1,442
0
votes
1
answer
224
views
SQL CLR function bad performance comparing to .NET App
In our system we are hashing passwords with the following method.
public static string HashPassword(string password, byte[] salt)
{
if (salt == null)
{
throw new ArgumentNullException($...
- 377
2
votes
1
answer
118
views
How to improve query performance on large time-series container in GridDB Cloud?
I’m using GridDB Cloud (Free Tier) with Python to store time-series IoT data.
My container currently has around 10 million rows, and it continues to grow daily.
Schema:
device_id STRING,
created_at ...
- 67
4
votes
1
answer
115
views
How to aggregate hierarchical data efficiently in Django without causing N+1 queries?
I’m working with a hierarchical model structure in Django, where each level can represent a region, district, or village. The structure looks like this:
class Location(models.Model):
name = models....
-1
votes
1
answer
132
views
Improve name search performance across FirstName/LastName (Hebrew + English) with paging on 3.1M-row join
I need to speed up a query that lists transactions from BillingInfo joined to site/customer tables. Users filter by CustomerName (first + last). Data volume: BillingInfo ≈ 3.1M rows
CREATE TABLE [dbo]....
- 17
0
votes
2
answers
223
views
Why correlated scalar is 10x times slower in MySQL comparing to PG
Let's create a table with 3000 rows
create table tt(id int, txt text);
insert into tt
with recursive r(id) as
(select 1 union all select id + 1 from r where id < 3e3)
select id, concat('name', id)
...
- 773
4
votes
1
answer
179
views
Why does 'Index Seek' read 20 million rows for `select max(uk) from T where uk <= @x`?
In a table T with 20 million rows and a unique constraint on integer column uk, the following query induces SQL Server 2019 to perform a scan of all index entries instead of a single seek:
select max(...
- 4,898
0
votes
1
answer
273
views
How to optimize slow TypeORM find() query with multiple nested relations in NestJS?
I am working in the backend of an application. One part of this application (like every application nowadays) is using AI for multiple things. The application's main purpose is building data warehouse ...
- 23
0
votes
1
answer
98
views
How do I benchmark queries in PostgreSQL? [closed]
I'm learning PostgreSQL Clustering abilities and I would like to compare performance of the same query with table not clustered and with table clustered.
I tried to generate 25 million user events and ...
- 1,224
0
votes
3
answers
51
views
How to achieve target of 10KTPM in one minute using jmeter
I am working on one scenario where I have to check login flow of application for 10KTPM in minute.
In my login flow exist- load the URL, Login and Home page load.
In entire login flow we have 55 ...
0
votes
1
answer
107
views
Cassandra Java driver: high latency when executing many async reads in a loop
We're using DSE 6.0.18 (Cassandra version 3.11) and our application is both read and write heavy.
I have a situation where I need to fire N number of read queries for each API (by partition key) using ...
0
votes
1
answer
97
views
"Query Targeting: Scanned Objects / Returned" Exceeding 1000 – How to Fix?
I'm using MongoDB Atlas and noticed a warning in the Performance Advisor and monitoring dashboard:
"Query Targeting: Scanned Objects / Returned" has gone above 1000
From my understanding, ...
- 134
0
votes
1
answer
78
views
Evaluate the memory usage of a View being used to populate an AAS table
I need help evaluating the actual execution plan of an SQL Server View:
https://www.brentozar.com/pastetheplan/?id=zAFOrTkUxr
Context
The above View is being called by Azure Data Factory to populate a ...
- 57
0
votes
1
answer
45
views
mongodb compound index for $or query
For the following query, what indexes should I create
$match:{
"from_time": {
"$gte": "2024-12-17T18:00:00.000Z"
},
"to_time": ...
- 141