Category "performance"

DELETE CASCADE in PostgreSQL extremely slow

I have a table "studies" with 14 subtables that are connected to "studies" via a foreign key that refers to the primary key in "studies". I need to delete all r

Profile CPU Usage of DSP objects in Realtime

Description Our Application is based of DSP synthesizer mostly used to create music, written in C Language, and I want to create a system-wide feature to give v

Pyspark performance tunning - cache or not to cache?

I am trying to speed up the calculations from multiple operations that I am adding as columns in a pyspark data frame, when I found the sparkbyexamples article

Lighthouse Performance improvement for flutter [Scroll]

So I've build a static website using flutter (web-app) which is hosted on Firebase Hosting. I checked my Lighthouse report using DevTools by chrome, and i get t

Speed up millions of regex replacements in Python 3

I have two lists: a list of about 750K "sentences" (long strings) a list of about 20K "words" that I would like to delete from my 750K sentences So, I have to l

Google Lighthouse Performance Calculator Formula

I'm trying to mimic Lighthouse performance calculator but I don't know the formula for it. Say the weighted percentage from their website is: FCP : 10% SI : 10%

Loading CSV with fread stops because of to large string

This is the command I'm using : dallData <- fread("data.csv", showProgress = TRUE, colClasses = c(rep("NULL", 2), "character", rep("NULL", 37))) but I get t

Python: Print string in reverse

Write a program that takes in a line of text as input, and outputs that line of text in reverse. The program repeats, ending when the user enters "Done", "done"

Group multiple HTTp samplers as one transaction, and have constant throughput

In my application, I would like to combine a group of HTTP samplers as one transaction, and have a constant throughput on the group.. ie. when I created a threa

i have problem with compress my images please advise me best way, this in my code

I am trying to develop an image_compressor web project. I am confused about the best image type for faster page loading speeds and best compression practices. P

Is there a more efficient way to find index of an element without using list built-in functions?

We can get the index of an element in a list using the .index() function. I was wondering if there's any more efficient way to find the index without using the

Python ONVIF GotoPreset failed to set global movment Speed

I'm trying to set the point called "Preset001" with a well-defined Speed but I can't as I get the following error on console: My camera's hostname: MYCAM gotoPr

Performance of c# FileStream.Seek vs FileStream.ReadBytes. Why is the latter faster?

In my application I need to frequently move the position pointer of a file stream forward a small number of bytes. Experimentation with using FileStream.ReadByt

WP Slow queries / Duplicated queries - images

I have problems with slow and duplicated queries, I'll need assistance, I'm working on this for more than 10h+. Latest WP version - Latest Flatsome theme and ju

Emulating Polymorphism without virtual pointers/overhead

Before reading I must emphasise I have demanding performance requirements (not premature optimization- processing millions of messages and need to design with p

Performance problems with the C++20 spaceship operator?

Since C++20 the standard library uses the spaceship operator to implement comparison for strings and vectors (according to this video). I am worried that this c

The intellij idea takes up a lot of Ram [closed]

The intellij idea takes up a lot of RAM, is there a way we can reduce the program size?

I want to refactor my loading game script

I wanted to load my save files in Start() but I got an error that there is no path to load file because the path is created in Start() so I changed loading plac

AVX2 code cannot be faster than gcc base optmization

I am studying AVX by writing AVX code with inline assembly. In this case, I tried to implement AVX in a simple function. The function name I made is lower_all_c

Why SCHED_FIFO threads are assigned to the same physical CPU even though idle CPUs are available?

While debugging some performance issue in app I'm working on, I found out weird behaviour of kernel scheduler. It seems that busy SCHED_FIFO tasks tend to be sc