2,607 questions
Advice
0
votes
6
replies
112
views
Database design: to normalise or not?
I’m wondering when designing a database, is really strict normalization better or do you denormalize for performance from the beginning? It’s better because it runs faster right?
Best practices
1
vote
1
replies
63
views
What are the best practices for implementing enterprise data archiving in large organizations?
We are planning to implement an enterprise data archiving strategy to manage large volumes of historical and inactive data across multiple enterprise applications (ERP, CRM, and legacy systems).
Our ...
Best practices
0
votes
15
replies
6k
views
Any advice on Inner Join query performance
I have a T-SQL query shown here which is taking forever to run.
I am trying to see if there is a better way to write the Inner Join statement. The source table has a millions of rows.
Is there any ...
- 1,344
0
votes
2
answers
257
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
84
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,449
0
votes
1
answer
297
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
142
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
136
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
143
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
-1
votes
2
answers
235
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)
...
4
votes
1
answer
203
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,948
0
votes
1
answer
362
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
151
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,254
0
votes
3
answers
60
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
143
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 ...
