Most voted "performance" questions
For questions involving measurement and improvement of code efficiency
Learn more…479 questions
Sort by count of
-
8
votes3
answers24407
viewsWhat is the performance difference between BIGINT and INT in Mysql?
There is some negative impact on the performance of Mysql, where the Primary Key is the type BIGINT(20), instead of INT(11)?
-
8
votes2
answers174
viewsGrouped id rendering speed vs class
Some time ago I saw some CSS rendering tests using id be faster than rendering using class, due to the amount of id be often lower in the document than the number of classes (one of the tests you…
-
8
votes2
answers540
viewsHow does an index improve the performance of a query?
Why does creating an index improve the performance of a query? Is any change made to the table structure? Is the data structure for disk storage modified? Is the algorithm used to perform the search…
-
8
votes2
answers1863
viewsHow to decrease compilation time?
I have a Solution with 20 projects, and most have a dependency relationship with each other. The build time takes a lot (6-8 minutes - may seem small, but it does a lot of damage when testing), even…
-
8
votes4
answers662
viewsHow to improve SQL performance with IN clause?
I have this SQL here: SELECT id, nome, url FROM categorias WHERE status = 1 AND id_ls IN (SELECT id_categoria FROM cliente_categorias) GROUP BY url What he does is seek only categories that have…
-
8
votes3
answers948
viewsWhat makes a JOIN bad in a database?
Where I currently work I had to make some queries in the database to generate a report or take emails from students who did not do remakes in other courses. However, I was given the idea of making…
-
8
votes1
answer62
viewsDo exceptions cause problems for performance?
When working in an application whose performance is important, NO USE of exceptions. With this comes doubt "what makes the exceptions so bad for performance?" In practical terms what is the need to…
-
8
votes1
answer641
viewsWhat is a reference location?
There are several answers here that talk about locality of reference, but do not explain what is. Where it is applied? And why it’s so important for data structures and algorithms?…
-
8
votes2
answers2392
viewsWhat is the meaning of the term "Hard Coded"?
What the term means Hard Coded? It is considered a bad programming practice? How to exemplify a code Hard Coded and its consequences from development to end-user use?…
-
8
votes1
answer178
viewsPython 64 bits have advantage?
What is the advantage of using 64-bit Python over 32-bit Python? It would be performance?
-
7
votes2
answers1259
viewsDifference in performance and use situation of numerical types
I’d like to know the difference between the guys Long, Double, Float, Decimal and Int, taking into consideration when is the best use in real cases. Ex: "uses float in interest as it is...". And…
-
7
votes1
answer326
viewsC#. Net blocking or non-blocking?
Do the System.Net.Sockets library, using asynchronous operations such as Beginreceive(), Beginread() and Beginsend() work in blocking or non-blocking ways? If I have 100 connections, it will be 100…
-
7
votes2
answers160
viewsWhat happens when we run PHP scripts with long tasks?
I’m running a script PHP who is responsible for downloading 55'000 images on one server and downloading these files into a folder on another server. It should take statistics per minute about 1.40…
-
7
votes3
answers237
viewsjQuery influences the application’s "performance"?
I personally love and use the jQuery library. This library influences the "performance" of the application?
-
7
votes2
answers1444
viewsHow to organize code without losing performance?
Using functions instead of putting code directly influences a program’s performance ? For example: void minhafuncao(){ printf("Funcao"); } main(){ minhafuncao(); } in place of main(){…
-
7
votes1
answer713
viewsDoes number of columns influence performance?
When modeling a database, the number of columns can interfere with performance? Ex: Tabela1 possui 2 campos, 1 int pk e 1 nvarchar(50) Tabela2 possui 50 campos, 1 int pk e 49 nvarchar(50) Select…
-
7
votes1
answer592
viewsCan Hard Drive Defragmentation help my server perform?
I always hear that it is necessary to "defragment the hard disk". But I never specifically knew the internal processes involving that operation. A doubt for example is: How software can perform this…
performance operating-system language-independentasked 9 years, 10 months ago Wallace Maxters 102,340 -
7
votes1
answer234
viewsMy CSS file is very large and it is difficult to maintain readability
My CSS File is close to 10,000 lines. It’s getting too complicated to maintain this file. in its Development version the file "weighs" 170kb and in its minified version, "only" 128kb Some points to…
-
7
votes1
answer1859
viewsDifference between a blocking language and a non-blocking language
In practice, what is the difference between a blocking language and a non-blocking language? What differences can we see in both front-end and back-end? Using an example, let’s imagine an endpoint…
-
7
votes2
answers1801
viewslist.foreach vs foreach
I have a list of several string, there’s a difference between going through the list values: In this way: ListaString.ForEach(delegate(string str) { Console.WriteLine(str); }); Or this:…
-
7
votes1
answer2978
viewsPagination with large amount of data
Thinking about performance, what is the best way to paginate a large amount of data? I’m currently wearing a List<Produtos>, keeping around 500 products in it, and using subList(min,max),…
-
7
votes1
answer1284
viewsCin vs scanf, which is faster?
In competitive programming it is common for several programmers to use scanf() and printf() in C++ code instead of using cin and cout. And I’ve even seen problems that result in a Time Limit…
-
7
votes1
answer3570
viewsWhat is the purpose of using inline functions in the C language?
I would like to know what is the purpose of functions inline in the language C? Is there any difference in performance or other characteristics that should be taken into account in comparison to…
-
7
votes3
answers1360
viewsFaster way to access properties in a C#list
I have a project that works with a large volume of data, and I need to optimize it to bring results of some calculations in a considerably small time. I know that I have several aspects to take into…
-
7
votes3
answers1253
viewsWhat is Gzip? How does it improve a website?
How exactly Gzip improves a site’s performance? I wonder what it’s like under the table. I saw that some sites that test the speed of other sites usually check the gGzip, but what is this? How…
-
7
votes2
answers299
viewsCompared to Datetime class, is the date function more performative?
It is very common to read some tutorials or articles saying that programming Object Oriented can cost more (I speak in relation to memory). Since I started programming, there’s that little itch in…
-
7
votes1
answer649
viewsDo I need to close the connection in each query?
Currently I have a web application that queries multiple databases in the same controller. For each database I request a connection at the server startup and keep them in a static class where the…
-
7
votes3
answers190
viewsConsole, Windows Forms or MVC what’s the fastest for heavy loads?
I’m developing a program that will basically have the following cycle: Database query(some milliseconds) For each record will perform the following process: Início | Parse de um XML web (alguns…
-
7
votes1
answer443
viewsSome of the real solutions to render lock error and improve performance
Well, lately I’ve seen, in articles about performance, some Angouts, and also in groups on social networks, about such a "blocking of rendering content above the edge". But what is this mistake ?…
-
7
votes2
answers351
viewsReadability of javascript codes
When writing a code you must do it so that the time required for your understanding is minimal. This is the most important metric to have a readable code and is the foundation of the fundamental…
-
7
votes2
answers223
viewsIn SQL queries should I follow the order of the index?
If in my table X an index is created with the fields A, B and C (in this order), in the SQL queries I must follow exactly this order? Example following the order of the index: SELECT * FROM X WHERE…
-
7
votes1
answer94
viewsSQL Server JOINS vs Subquerys
I was making some queries, and came the need to carry out the grouping of a table that was in a JOIN within the query. To illustrate. Sales chart. +----+---------+------------+----------+ | Id |…
-
7
votes1
answer404
viewsWhy are certain languages faster than others?
I’ve heard a lot about how C is faster than C++ and Java, Lua is the language of script faster, among other examples. What makes certain languages faster than others? What defines a language as…
performance characteristic-language language-independentasked 5 years, 11 months ago NinjaTroll 1,752 -
7
votes2
answers102
viewsDo partial imports bring advantages to the application?
Some languages have as a resource the import of parts of the library used. Using Dart as an example we have two types of partial Imports showand hide . import 'package:google_maps/google_maps.dart'…
-
7
votes1
answer88
viewsWhat are Core Web Vitals and how do they work, should I worry about them?
I saw recently that Google will consider the reports of Web Vitals (Lighthouse and Search Console) as a factor of rankings, because these factors can directly interfere with the user’s experience…
-
6
votes1
answer475
viewsWhat can cause the RU’s performance to fall in this scenario?
I’ve been making a data import for a project on ASP.NET MVC 5 with EF 6.1 and SQL Server 2008 where the import data source was a file txt. The record lines of the file were not very large but…
-
6
votes1
answer115
viewsRunning an app under development on a real device impairs its performance?
I’m worried about running my app in development on my device. Could someone tell me if this undermines performance, leaves a lot of junk, leaves doors open and vulnerable on it?
-
6
votes2
answers189
viewslimit the for, php
Good is the following, I am generating pagination links to get more lightness in my system, the problem is I have many records in the database and this pagination generates many links, thus…
-
6
votes3
answers301
viewsWhat is the advantage of using include de array vs configuration file?
I have observed some codes where the programmer does the following: /** Arquivo A.php */ return array('databaseName' => 'bancoTeste', 'port' => 5208); /** Arquivo B.php */ $configs =…
-
6
votes3
answers436
viewsWhy is array_shift considered a slow function?
According to the Manual, array_shift removes the first element of the array. I have seen many criticisms on the Internet about the performance of this function, because it reorder the whole index of…
-
6
votes2
answers4961
viewsCalculate how long it takes to execute a function
I have to create a function in JavaScript that takes all id’s from one table and makes a draw with id’s from the same table so that the same id does not fall with itself, and there is a possibility…
-
6
votes1
answer155
viewsC++ overhead in method header
I’ve been analyzing the performance of a Directx renderer through the VS2015 Performance Profiler tool and it pointed me to an overhead in the header of a very requested renderer method, as shown…
-
6
votes2
answers592
viewsBetter performance for few accesses: Hashmap or Treemap?
I use the structure a lot java.util.HashMap<K,V> even for small scopes with few inputs (up to 50). But I’ve been wondering if the structure java.util.TreeMap<K,V> would not be better for…
-
6
votes2
answers606
viewsWhat is a tail recursion?
In that question I asked about performance. One of the users replied that the compiler does several interesting optimizations, such as inlining, Loop unwinding, tail recursion and caches. How Tail…
-
6
votes1
answer278
viewsImporting specific modules is faster/performative than importing everything (with the asterisk)?
In Python, since I realized that it is possible to import specific functions or classes from a module, I chose to always do so. One of the reasons is legibility. The other reason I’m not sure, so I…
-
6
votes1
answer857
viewsAny CPU or x64?
I searched for compilation on Any CPU and x64, but found nothing regarding performance and file size. There is difference between these two in this question when the machine is x64? Website using C#…
visual-studio performance compilation x64 jitasked 8 years, 2 months ago Fernando Augusto De Almeida Ba 91 -
6
votes2
answers216
viewsHow to select only the characters I want from a font?
I would like to decrease the font disk size so that the page loads faster. It is the font of Font Awesome icons. I want to know if there is any tool so I can remove the characters I don’t use and…
-
6
votes1
answer138
viewsWhy is Offloading for the GPU a good idea?
I follow some forums on the Internet and I realize that recently there has been much talk of holding Offloading tasks for the GPU. Mozilla has implemented a new engine for its browser called Servo.…
-
6
votes1
answer298
viewsPerformance differences between structs and classes
I know the difference between structs and classes is that structs has its public members by default, and that structs belong to C (but nothing prevents use in C++). In practice when creating an…
-
6
votes1
answer142
viewsIs it worth using binary operators to gain performance?
I have the following situations: if (1 & 1){} and if (1 == 1){} According to what I’ve learned, working with bitwise Operators causes a much better performance in the program, with this I came…