Most voted "performance" questions
For questions involving measurement and improvement of code efficiency
Learn more…479 questions
Sort by count of
-
0
votes0
answers306
viewsWhich is more performative: "WHERE id IN (?, ?, ...)" or "WHERE id = ? OR id = ? (...)"
I am not an expert in Mysql, but I am studying and lately I am trying to improve some codes of my programs and I came across this situation. I wonder if there are differences between the querys…
-
0
votes1
answer387
viewsBank Consuming all memory
Good day I am with a problem , users of a given system are having problems when consulting a name in the system "a simple search" I joined the bank and noticed that in sql there are several banks…
-
0
votes1
answer55
viewsIs it a problem for me to work only with reading a file with it open in both write and read mode?
I’m starting to work with C files and need to do the skeleton of a book registration program, saving the information in a file. My question is whether I should work with the files like this, opening…
-
0
votes0
answers64
viewsCHALLENGE: MQO curve adjustment or similar with minimization of other types of error measurements
Context The MQO (ordinary least squares) method is known to receive: a function model f parameter x (which can represent several parameters) from a model with coefficients c[1], c[2], ..., c[o],…
algorithm performance mathematics numerical-analysis square-minimaasked 5 years, 8 months ago RHER WOLF 1,529 -
0
votes2
answers85
viewsPerformance between creating multiple objects or just one
I always had a question regarding the code blocks below, which would behave faster taking into account the service: foreach(var t in listaT) { using(TService service = new Tservice()) { t =…
-
0
votes1
answer102
viewsIs there a performance gain in concatenating strings directly into SQL?
Actually, I have a code kind of like this: const users = await query(` SELECT "id", "username", "email" FROM "users"; `) .then((users) => users.map((user) => { user.id =…
-
0
votes0
answers123
viewsIs ROWCOUNT reliable for change checking?
I am mounting a query to be executed via DAPPER/C#, my idea is not to check if the data exists in the table returning the object to the application, but rather, to check directly in the data bank of…
sql-server performance sql-update software-architectureasked 5 years, 1 month ago Marco Souza 12,304 -
0
votes1
answer231
viewsHow to make Lazy loading correct at Angular 6, not known component error
I’m trying to do Lazy loading to load certain modules when hitting the URL that really needs to load these modules, however I am getting the following error: core.js:1673 ERROR Error: Uncaught (in…
-
0
votes1
answer58
viewsHow to make the number of executions of an algorithm a function of processing capacity and not of time?
I wrote a little program to send a message on my father’s Whatsapp to remind him to take his meds. Below I present the code that can be replicated by anyone with a mobile number and a record in the…
-
0
votes0
answers26
viewsDoubt autocannon working
I have read several times the autocannon documentation, but when I look at the result tables I cannot understand. In the first table, the second column shows 2.5%-5ms. Does this mean that 2.5% of…
-
0
votes1
answer70
viewsAlgorithm performance in JAVA
Good afternoon, you guys. I have the following exercise to deliver: Challenge Mr Milli, Petland City resident, is the famous owner of the world’s largest board game factory. Recently, he had the…
-
0
votes1
answer41
viewsWhy fractionate an Insert improves its performance?
Supposing I have a table order_items that records the items of an order, and in this example, the user would be making 1 order from 10,000 computers. At the time of registering the order items in…
-
-1
votes1
answer246
viewsIs it feasible to use Mysql with Entity Framework 6 and get good CRUD performance?
It is feasible to use Mysql with Entity Framework 6 and get good CRUD performance?
-
-1
votes1
answer187
viewsWhat’s worse a "Where" or "Join"? Which is more expensive?
What’s worse a where or join? Which is more expensive?
-
-1
votes1
answer74
viewsDoubt about alternative to decrease code size and make fewer queries
I have a question regarding a certain part of a system that I am developing. The system is for management of a higher education institution and has a page that is to administer the courses of the…
-
-1
votes1
answer256
viewsWhich of these 3 PDO codes has the best performance?
Purpose: Select a single line with LIMIT 1 Internal Use: The selects receive only internal parameters You don’t need PREPARE because there is no external user data $pdo = new…
-
-1
votes1
answer31
viewsPerformance - Separate log tables or leave them in the same database
everything jewel? I have a mysql database approximately 180mb in size. Each month the application automatically creates a new table with access logs and actions, which in 14 months are totaling 80mb…
-
-1
votes2
answers52
viewsFor better performance in the Postgresql database is it better to have the products divided into smaller tables?
Hello, I’m developing a system to manage the sale of several real estate developments. In this system each enterprise has a group of units available, type "Apartment 21 - 2nd Floor, Apartment 34 -…
-
-1
votes2
answers70
viewsWhat’s the fastest way?
I made a little game in Java and the players' dice are in the database, when a player enters, he is placed in a ArrayList<PlayerData> where it contains the getters and setters of level, money…
-
-1
votes3
answers229
viewsPython is not so "smart" for redundant operations
Unlike many cases in c++, Python is apparently not so smart to optimize redundant operations, even between constants. I made a simple benchmark to test math.cos inside and outside a loop. In this…
-
-1
votes1
answer87
viewsCode takes time to execute, points error but then displays the result
Code on net Beans runs, but it takes time to show the result. Error appears in the netbeans console, but if I leave the program running after a while it shows the result: #include <stdio.h>…
-
-1
votes1
answer47
viewsPerformance JSON x Properties in Java
Good night. I used to use several files .properties to save the data from the desktop application I develop. I studied the possibility to exchange these files for files .json, because I see that…
-
-3
votes1
answer114
viewsPerformance difference between C and Matlab
Friends, I created two apparently identical encryption codes, one in C language and the other in Matlab, the code in Matlab has more functions, that is, it is more extensive and performs more…
-
-3
votes1
answer1838
viewsWhere to insert JS and CSS files into HTML?
Thinking of performance, in which part of HTML should I insert CSS and JS files. I know which JS files should be inserted before closing the tag </body> not to block charging and if possible…
-
-3
votes1
answer107
viewsUsing Math Tricks, can you speed up Python accounts?
An example of code about my doubt. %timeit lambda : 10000000000000000*10000000000000000 40.4 ns ± 0.592 ns per loop (mean ± std. dev. of 7 runs, 10000000 loops each) %timeit lambda :…
-
-4
votes1
answer319
viewsMysql queries always busy
I have a task cron which obtains remote data every 2 minutes, via webservice, by entering the values obtained in a database. At the end of each day, more than 50,000 records are created. The problem…
-
-4
votes1
answer159
viewsImprove the performance of a pointer method
Here’s the code working: string string_pick(string text, string tag, char caractere) { int index = text.IndexOf(tag); return text.Substring(index + tag.Length, text.IndexOf(caractere, index +…
-
-4
votes1
answer144
viewsIs the conditional structure "if Else" more performative than a "switch case"?
There are major differences in performance between the conditional structure if else and the switch case within a program?
-
-5
votes1
answer241
viewsWhat is the most efficient way to make string literals not appear in compiled code?
What is the most efficient way to make literals of string do not appear in compiled code? I want to prevent reverse engineering. To do this, I tried the following code. However, I am concerned about…