102,745 questions
Best practices
0
votes
6
replies
42
views
Micro benchmarking: how to measure multi-threaded CPU time?
I'm attempting to benchmark a custom queue implementation with X consumer and Y producer threads. A single run takes on average ~68ms, and I've noticed that my benchmarking library sometimes produces ...
- 3,075
Tooling
0
votes
4
replies
100
views
How can I make a custom programming language run closer to C-level performance?
I'm building a custom programming language and want performance close to C.
Currently I'm deciding between:
Generating C code and compiling with GCC/Clang
Generating LLVM IR directly
Using a JIT
My ...
0
votes
1
answer
120
views
Why is DELETE much slower than TRUNCATE even when deleting all rows from a table in PostgreSQL?
In an application cleanup job, I need to remove all rows from a table regularly.
Table:
CREATE TABLE session_logs (
id BIGSERIAL PRIMARY KEY,
session_id TEXT,
created_at TIMESTAMPTZ, ...
- 155
-2
votes
0
answers
53
views
YOLO26 with CPU [closed]
I'm trying to run YOLO26n on my core i5 CPU, which basically detects three things: Helmet, falling, and oil spill, so the performance is getting worse, but what makes it the worst is when I try to get ...
Best practices
0
votes
8
replies
90
views
Speeding up SPSC Queue on C++
I started learning C++ recently and I am working on SPSC Lock-Free queue. Full code of my benchmark can be found here: GitHub. What I do, is basically pinning my Producer and Consumer threads to CPU's....
- 302
1
vote
1
answer
145
views
Improve the performance of code that builds an object by comparing two objects
I need a faster way to build one object from another in PowerShell.
I have a PowerShell array of Strings with 10,000 hostnames:
$hostnames = @("server1","server2","server3&...
- 1,530
Best practices
0
votes
1
replies
48
views
Best approach to implement cascading filters (45 columns, up to 10k values each) in React + Spring Boot with SQL backend
I have a React UI with a Spring Boot backend that retrieves data from a SQL database.
The screen contains around 45 filter columns, where filters work in a cascading way. For example:
Selecting a ...
- 1
Advice
0
votes
0
replies
33
views
How to efficiently fetch data from Metropolitan Museum of Art Collection API?
I am working on a project where I need to fetch and display a large dataset (similar to the Metropolitan Museum of Art collection API). The dataset contains thousands of records, including images and ...
- 1
Best practices
0
votes
0
replies
55
views
Audit table: efficient query for recent rows when filtering on non-partition column of TimescaleDB hypertable
I have an audit table using a TimescaleDB hypertable:
CREATE TABLE log.data
(
modified timestamptz not null default clock_timestamp(),
table_schema text not null,
table_name text not ...
2
votes
0
answers
53
views
Why does this distributed matrix multiplication become slower when using two nodes?
The following ScaLAPACK code gets 3.8 Tflops on one node, but only 1.5 Tflops on two nodes. After that, it scales well. I don't understand why we get an initial slowdown. The matrix is about 50K x 50K....
Best practices
0
votes
1
replies
53
views
What are safe techniques to reduce latency in a backend application without compromising correctness?
I am working on a backend application and trying to reduce response latency, but I want to avoid optimizations that could introduce correctness issues.
By correctness, I mean preserving accurate ...
0
votes
1
answer
84
views
Java Segment Tree with Lazy Propagation getting Time Limit Exceeded on CSES *Range Updates and Sums* [closed]
I am solving the CSES problem:
https://cses.fi/problemset/task/1735/
I implemented a segment tree with lazy propagation to support:
Range increment updates
Range assignment updates
Range sum ...
Advice
1
vote
9
replies
112
views
Does flipping from/to dates within date index make it more selective for SQL Server
In one of my projects I have an entity with startDate (from) and expiryDate (to):
@Entity
public class BlacklistedItem {
//...
@Column(nullable = false)
private LocalDateTime startDate;
@...
- 4,664
Tooling
0
votes
6
replies
95
views
Running 32bit windows application inside docker (or Linux wine)
Hi I’m a student software engineer
my group project requires us to run an 32bit windows application (metatrader 4) to run some calculations.
Currently we have an vm setup to handle this but our ...
- 1
-1
votes
1
answer
138
views
Optimization of entropy-based wordle solver on haskell [closed]
My wordle solver seems to be slow, i would like to ask your opinions on how i can speed it up further
I did some optimizations i could think of, but speed still seems to be bad
As far as i understand, ...
- 31