Questions tagged [performance]

For questions pertaining to the measurement or improvement of code and application efficiency.

0
votes
0answers
9 views

Dask worse performance than Pandas

I am running the same functionality using Pandas API and Dask API. I expected Dask API to be faster, but it is not. Functionality I cross joint 2 dataframes (pandas and dask respectively) by a '...
-4
votes
0answers
21 views

Memory consumption for micronaut microservices

I have a question about performance. I have built some microservices cloud-oriented with micronaut. I deploy those services in Kubernetes and the performance is like: CPU: super good, they barely do ...
1
vote
0answers
42 views

What is the fastest way to select and count rows based on multiple date conditions?

I have created function for calculating number of sold items by given column value (specific vendor or shop) in a calculated period of time. What is the more efficient way to write below function? ...
7
votes
1answer
106 views

Inconsistency when benchmarking two contiguous measurements

I was benchmarking a function and I see that some iteration are slower than other. After some tests I tried to benchmark two contiguous measurements and I still got some weird results. The code is ...
5
votes
1answer
64 views

Is there a more efficient way to assess containment of strings?

I have to execute this line of cose several million times, I wonder if there is a way to optimize it (maybe precomputing something?). a.contains(b) || b.contains(a) Thank you edit: the code ...
0
votes
1answer
91 views

How to find the duplicates in an array in O(1) time in Java?

I am given a task to find the duplicates in an int array in O(1) time. My approach is to first sort the array and then find the duplicates using a linear search. I first used to sort the array by the ...
2
votes
2answers
45 views

Materialized view Vs Temp tables in Oracle

I have a base transaction table. Then I have around 15 intermediate steps, where I'm combining dimension tables, performing some aggregation and implementing business logic. The way I'm handling ...
0
votes
0answers
6 views

Twilio Programmable Chat really slow on device

I've been building an app in React Native and part of it uses Twilio Programmable Chat. Everything runs great on the iPhone simulator but when I put a build on my physical device it runs very slowly. ...
0
votes
0answers
19 views

Obtaining wrong error-curve for logistic regression (Bug in Code)

I started machine learning and wrote this code. But for some reason I am getting zig-zag error curve instead of a decreasing logarithmic curve. The "form_binary_classes" for now does nothing but take ...
0
votes
0answers
17 views

poor performance of paintComponent() on JPanel

I have a performance issue with the code I post here. I am a JAVA newbie and I am trying to repaint Images on a JPanel which is then displayed on a JFrame. After a lot of trial and error the code ...
0
votes
1answer
27 views

Accessing CSS styles with JavaScript is too slow

I'm creating a simple gravity physics game with JavaScript. I had hardly gotten started when I realized I was probably doing something wrong, because it was going EXTREMELY slow. I am using circular ...
1
vote
1answer
23 views

JMeter - Response time has same value as latency

I'm executing performance testing using JMeter and Blazemeter report, but the response time value is the same as latency time value. can somebody explain? I attach the graph results: Latency Time ...
-2
votes
1answer
59 views

for (var i = 0; i &lt; count; i++) { } == for (var i = 0; i < count; i++) { }. What is this notation and why use it? [on hold]

Ran into the notation: for (var i = 0; i &lt; count; i++) { } on this tutorial. I gather it is equivalent to: for(var i = 0; i < count; i++) { } What is this notation? Why use it? Does it ...
0
votes
0answers
11 views

NodeJS rest API running on AppEngine Latency issue

Currently my rest api build with Express in node is running on Digital Ocean. I'm doing the switch to Google App Engine. When I run my API on Digital Ocean, for a specific request the response time ...
-1
votes
0answers
10 views

How fast is PyPubSub?

I have been using the PyPubSub module recently for event handling. I am curious about the speed in which signals are delivered. Consider the following example: (Not using PyPubSub) I have one class ...
1
vote
0answers
30 views

How to implement multithreading in a Java ray tracer

I'm writing a ray tracing program in Java and have implemented multithreading using Runnable interface. Each thread renders a portion of the 800 vertical lines. When using two threads, they will ...
0
votes
1answer
40 views

Why wget wall clock time much higher than download time? [on hold]

wget --page-requisites --span-hosts --convert-links --adjust-extension --execute robots=off --user-agent Mozilla --random-wait https://www.invisionapp.com/inside-design/essential-steps-designing-...
0
votes
0answers
42 views

How to implement multi keyword search in C?

I want to implement a case-insensitive text search which supports parallel testing of multiple keywords. I was already able to achieve this in a way which to me does not seem to be efficient in terms ...
0
votes
1answer
19 views

Extra constraints on columns not appeared in GROUP BY without JOIN

Consider the following table: Company BuildYear ProductName Cost ------ ----------- ----------- ---- Foo 1900 A_1 50 Foo 2000 B_1 50 ...
1
vote
1answer
39 views

Consecutive parallel computation with very low workload per invocation

Lets suppose i want to compute the methods A and B in the following example in parallel: while (true) { int state = NextState(); int a = A(state); int b = B(state); ImportantMethod(a, b)...
0
votes
1answer
10 views

Why using map in render slow/freeze app if there is a lot of entries?

I have a screen (n°1) with 1 button. When I click on it I have to wait from 1 to 4 seconds to see next screen (n°2) and it's really really slow and boring. I find the problem come from this line: {...
1
vote
0answers
17 views

How to accelerate specific process on Ubuntu

I'm executing pleskbackup on a Ubuntu 18.04 LTS‬ server to create a full backup. This task has already been running for over half a day now. While the server isn't nearly working to capacity. CPU: ...
0
votes
0answers
10 views

Log trace - to disable or remove

In a project, I have a lot of methods with several trace calls like this one: public async Task<TheReturnType> TheMethod() { var sw = Log.TraceStart($"TheMethod start"); ....... ...
0
votes
0answers
18 views

Best choice to do multicount in terms of performance in MongoDB?

I have to do multi counting in MongoDB. I have a collection of docs (around 1.5 million) like this: reportDocument { _id : Guid, status : number (enum value), name : string } with custom index ...
1
vote
1answer
17 views

How to fetch contents of @ElementCollection table mapped via @MapKeyColumn

There are many questions similar to this here but after a lot of looking, I have not found this question or an answer to it. I have an entity with an @ElementCollection mapped like this: @Entity ...
-1
votes
0answers
17 views

Kindly suggest easy plug in opensource tool for data monitoring for both windows and linux?

Kindly suggest easy plug in opensource tool for data monitoring for both windows and linux. My requirement includes monitor the cpu free memory, available memory, Total memory , cached memory as well ...
0
votes
3answers
39 views

Need help to optimize this Sql Query

I want some help to optimize this SQL Query. This is working completely fine. I just want to reduce the runtime of this query select distinct o.usrp_order_number,t.* from ms_bvoip_order_extension ...
1
vote
0answers
23 views

Optimize BLF-reader for Python CAN performance

I have a big blf file, blf_file.blf, and an associated dbc file, dbc_file.dbc. I need to read and decode all the messages and store them in a list. For this I use the python-can library: decoded_mess ...
4
votes
1answer
46 views

Python mmap - slow access to end of files [with test code]

I posted a similar question a few days ago but without any code, now I created a test code in hopes of getting some help. Code is at the bottom. I got some dataset where I have a bunch of large ...
0
votes
2answers
28 views

optimize linq query with multiple include statements

The linq query takes around 20 seconds for executing on some of the data . When converted the linq to sql there are 3 nested joins that might be taking more time for execution . Can we optimize the ...
1
vote
0answers
27 views

Jquery AutoComplete slows down after multiple clicks and hangs browser

I have few input tags which acts as autocomplete. JavaScript: function processAutoComplete(objEvent, strResult, strTypeOrSubtype) { if ($(objEvent.target).closest('.test-section[data-...
-2
votes
0answers
56 views

Is there a method to avoid null in display of a well working app?

I created an app. It worked well. I run it many times. It gave accurate results all the time. It has Previous and Next Button. I add TextViews of all the activities and display it in the last ...
-1
votes
2answers
43 views

is this bad to put a do-loop in another do-loop?

is this bad for performance that we put a do-loop in another do-loop? both of loops are in a timer, is this bad practice? Timer gamingTimer = new Timer(); gamingTimer.scheduleAtFixedRate(...
-1
votes
1answer
33 views

Performance comparing and doing querys with two really big CSV files in JAVA

I need to compare two csv files, each has around 500000 to 900000 lines (yes, they´re big), and I´d like to know which is the best way to do this. What I need to do Delete rows on CSV1 that are not ...
0
votes
1answer
46 views

Pattern for many-to-many request/result pattern

First, I apologize the for title, because it probably doesn't describe the problem well. I couldn't come up with a better one. I'll use a simplified example of the real problem I'm trying to solve. ...
0
votes
1answer
21 views

About performance and drawing Bitmaps

At the beggining i've to say that i'm learning java on my own and may make a stupidest mistake ever... I'm facing a problem with FPS drop while drawing Bitmaps in my 2d game. My game's map consists ...
3
votes
1answer
39 views

Is there a performance gain on x86 Windows/Linux apps in minimizing page count?

I'm writing and running software on Windows and Linux of the last five years, say, on machines of the last five years. I believe the running processes will never get close to the amount of memory we ...
0
votes
0answers
14 views

what's the relationship of loadaverage and iowait?

In linux, Does "load average" and "iowait" have some relationship? On Linux systems, high load means: 1) High CPU, because of some CPU-intensive tasks, the CPU can't handle it. 2) High IO, ...
0
votes
0answers
30 views

postgres cube euclidean distance query performance issues

I have a postgres database containing a table of documents with word embeddings of 100 dimensions and using it to find similar documents. CREATE TABLE documents( id bigint, title text, body ...
0
votes
0answers
16 views

Is there any alternative to run a code after an event

I'm using the following code(Given below). This code generate BASE64 encoded data of image which help me to show this data on IMG tag on HTML5. "Webcam.on" is a EventListener which will trigger when ...
0
votes
1answer
38 views

JavaScript: Out of Memory for huge result array in Sieve of Atkin implementation

Currently I'm running some benchmarks between JavaScript, asm.js and WebAssembly. For that I've implemented a little program that searches for primes with the Sieve of Atkin algorithm. To make the ...
2
votes
1answer
36 views

Why is 'wget --page-requisites' extremely slow

Goal My goal is to download a single webpage to be fully functional offline in the same time it takes a browser to request and show the page. Problem The following command downloads a page and ...
0
votes
0answers
21 views

Frequently called subroutines/functions: copy to each module and declare Private or keep in one module and declare Public? Performance?

I've got a few custom subroutines and functions in my main VBA excel workbook that I call from nearly every subroutine. For example: a Subroutine rng(), which takes in a starting cell's address of a ...
-5
votes
0answers
26 views

How to make SQL connection faster [on hold]

Application is taking much time to log on to SQL server to READ/WRITE data Every Line is taking more than 70ms to execute public readonly static SqlConnection con = new SqlConnection(ReadCS()); ...
0
votes
1answer
24 views

Low throughput with hazelcast queue as soon as multi-node cluster?

I use the test below to gauge my throughput times. When I run a local one-node cluster the throughput time is at around 90k messages/sec. As soon as I add another local node to the cluster, the ...
0
votes
1answer
80 views

How to increase performance of loop operation

I have a problem with the performance of my R code which checks my data frame for combinations with certain conditions. For each row in my data frame I need all the combinations where the variable "A" ...
1
vote
1answer
53 views

How to improve the performance of this insert statements for huge data ingest?

I have a requirement to insert huge (50GB of random data) into my database, so that I can use a backup application to check the de-duplication ratio. I have written a small procedure like below This ...
0
votes
2answers
39 views

Better performant quad-tree for moving and colliding objects

So basically I want to make a scene where around 50K Asteroids are spawned with a position and AABB (Axis Aligned Boundry Box) and move each one of them to a random direction which is generated in the ...
0
votes
0answers
21 views

How to optimaly merge two arrays of different objects based on an attribute?

First question here (I mean like ever), so sorry if I posted at the wrong section or haven't found an already given answer. I have 2 arrays of objects. The first one, lets call it oldArray has 1000 ...
2
votes
3answers
43 views

How to replace values of several columns based on/ another column in R?

I am a new R user and I am trying to make a code more efficient. I have a very huge dataframe that counts several columns. I am trying to replace the values of several columns based on the value of ...