Most voted "performance" questions
For questions involving measurement and improvement of code efficiency
Learn more…479 questions
Sort by count of
-
0
votes1
answer154
viewsMeasure access performance to Android’s Sqlite database
Good afternoon, How can I measure access performance to Android Sqlite database? More specifically database entry and selection.
-
0
votes1
answer114
viewsDifferences between SELECT, Count and Empty to work DB data
I, out of curiosity would like to know the differences between 3 seemingly equal things to count (Rows, lines) and get data from a table, in Mysql/PHP: 1st: Return the number of Rows first, and only…
-
0
votes1
answer599
viewsQuery Performance - Postgresql
I have the following situation, I need to bring data from a vehicle table of the system in which I work and another with integrated data of a partner system, for being integration the data are not…
-
0
votes1
answer103
viewsDoubts about table of states and cities
Friends good morning. I have a question, on the best way to fill a combobox with information of State and other with information of city. My doubt, consists in, what would be better in question of…
-
0
votes0
answers27
viewsFilter Used and Unused Classes Twitter Bootstrap
I’m importing bootstrap to a landing page, but because the content is little, the classes I needed to use are also few. I wanted to know if you have any automated way to filter which classes I am…
-
0
votes0
answers47
viewsLong-time running integrity of Java application
I have tested my Desktop application, and noticed that when I leave running for a long time I notice changes in the behavior of the actions that should be performed. My application runs using…
-
0
votes1
answer147
viewsDelay in massive processing of ajax Codeigniter
My code imports data from one database to another. To avoid server overload, I am importing 100 out of 100 records into each ajax. I noticed that in the first requisitions, it takes about 40ms,…
-
0
votes1
answer172
viewsWhen to use a scripting language?
When to use a language of script and what is the ideal setting for its use? I’ve been reading about languages script and I thought about the possibility of using them in my C/C++ project for a game…
-
0
votes1
answer130
viewsNative app performance is still far superior to html based app?
I am in doubt about which framework/language to use to start application development. From what I’ve read so far, I’m between using Ionic and Xamarin. Everywhere I read the great advantage of Ionic…
-
0
votes0
answers26
viewsSending to the database a series of data accumulated during the day, is it possible?
I came to a question, to store data of events and browsing that the user performs on the site, would it be possible to only send to the bank after the end of the day, the actions that users have…
-
0
votes1
answer520
viewsTime difference in execution of the same query between PHP and PHPMYADMIN
I am trying to improve the performance of my pages to improve the user experience, but, I am not able to identify the problem. According to Google, it is recommended that the pages respond in less…
-
0
votes0
answers42
viewsWhich html markup for menu, which consumes the least browser resources?
Below is a simplified version of the HTML markup of a menu I use: <ul> <li><a href="#" title="Teste X">Teste X</a></li> <li><a href="#" title="Teste…
-
0
votes1
answer1990
viewsWhat is the most efficient method to remove an item from Arraylist?
I would like to know which of the methods available by the class ArrayList is more efficient to delete an item from the list.
-
0
votes0
answers212
viewsImprove performance of COUNT Mysql
I have a web application that performs several queries, but a Count query is taking 2 seconds to search and return the data to the application. My table where I perform COUNT has about 230 thousand…
-
0
votes1
answer25
viewsArquivos Statics
Does anyone know how to use the files statics to improve site performance and speed? Like the great ecoomerces use: static1.netshoes.net/resources/lind/netshoes/lindd.min.js…
-
0
votes0
answers76
viewsMysql - What is the best input to be created in this case
Hello, I have a table in the database with the product price history. This table is very voluminous having more than 1 billion records. How can I create an index in this table, to meet the query…
-
0
votes1
answer453
viewsPerformance when comparing Varchar fields in SQL Server
To SQL below is causing much slowness by the fact that I use the Right(L.nrDiscado, Len(D.Descricao)) (believe me) to compare with the field D.Descricao: create table #TempNrDiscado (NrDiscado…
-
0
votes0
answers19
viewsWaiting for a page to load
I have a home page, and when I click a button, I navigate to the next page. The problem is that this page does a database query and returns many records, which are inserted in 3 listviews different.…
-
0
votes1
answer61
viewsInfluence on the chosen AWS region in performance
Logically, comparing two similar infrastructures, it is expected that the closer to the request user respond more quickly. For web applications in AWS in general (not being real time), the…
-
0
votes1
answer38
viewsPerformance at query time to database
Suppose I have a table with 100,000 records, which in this example I will call dictionary, and will have a LIMIT of 1000 results. SELECT FROM * dicionario Let’s say that hypothetically I have…
-
0
votes0
answers48
viewsQuery Performance - HELP
I’m making a query, but I am learning now. There is a way to improve the performance of this query? select a.COD_EMPRESA, b.Dat_pagamento from SAS_EMPRESA a full outer join SAS_ITEM_PAGO b on…
-
0
votes1
answer270
viewsWhat criteria should be analyzed when choosing a language for creating an application? Is performance everything?
I need to create an application that is the source of communication between several other applications with the database, IE, other applications will make requests for this application that will be…
-
0
votes1
answer49
viewsChange icon color in API 19 Kitkat
Since API 19(Kitkat) is still very popular, it is a good choice to support this version. However, it does not support several Eatures, such as backgroundTint and Imagetint. This puts me in several…
-
0
votes1
answer89
viewsHow to perform in systems?
How the issue of performance in software, websites and etc works.? Facebook transpired PHP in C++ to gain performance. How does it work? I know with C++ to set exactly the variables, but the…
-
0
votes2
answers663
viewsLeft Join or Sub-Select? which one has the best performance?
I’m studying which one of the fairs below would perform better. So I wrote them both and ran them in the same database with the same data: Query 1: select a.numeroOp as OP, a.codigo as CÓDIGO,…
-
0
votes1
answer180
viewsSlow matplotlib (Python) to plot a 2-D graph?
Lately I came up with the need to use Python for plotting graphics with more than 3600 coordinates, but I realized that time can be a problem, but I’m not sure if the code I did has any performance…
-
0
votes1
answer316
viewsGenexus applications generated for C# have slower 64-bit performance compared to 32-bit execution
I have a problem in an application made in Genexus that doesn’t seem to me with much sense. My Genexus settings are: Genexus X Evolution 2 Upgrade 7 Build 109528 Generator C# Environments I tested:…
-
0
votes1
answer694
viewsUsing Input or declaring in metadata?
have the following doubt: Today as far as I have seen there are 2 ways to receive information in an Angular Component. But I doubt the question "performance". The example below I import the Input…
-
0
votes1
answer26
viewsSave information about execution days
Good afternoon, you guys. I have an automation monitoring system that consumes a table that contains information about n automations registered, about 40 currently. I would however like to do a…
-
0
votes1
answer259
viewsIs the Node server the only option to support maximum level of requests in an application?
For an application project you will need to support on the server an immense amount of requests such as a e-commerce on the day of black Friday or the server of a game developer on the first day of…
-
0
votes1
answer45
viewsMongo driver for php only works with mpm_prefork?
Seeking a better performance for my application I changed the MPM of apache of prefork for event, but when restarting apache with the new processing module the mongodb does not work, while accessing…
-
0
votes1
answer104
viewsUse findViewById in all scopes or use a variable?
Which of the most recommended strategies for a good application performance? Using findViewById whenever we use some element of View or to do so only once by assigning to a variable? example in…
-
0
votes1
answer54
viewsPerformance between index() and hashmap . get()
I’m having a performance issue with my application and I’m thinking it might be the various .get() that I give, this way I’m considering transforming these hashmaps for arrays and use the indexOf()…
-
0
votes1
answer80
viewsLoad pages without images and css in Phantomjs
Does anyone know any way to load a page faster using phantomjs... Because I have a bot that goes through certain pages through pagination, however I need a way to improve the loading time of these…
-
0
votes2
answers32
viewsProgram performance in order of module loading
Someone would tell me if there is a relevant difference in the performance of a program (in this case, done in Python) when importing all modules to be used from the beginning of the code instead of…
-
0
votes0
answers54
viewsHow to increase the performance of a search with for
Basically the program I did does this same procedure, but with more data. I need to increase search performance, of course this can be done with libraries if it’s better. No matter how you improve…
-
0
votes1
answer180
viewsFast calculation of square root and its multiplicative inverse in float
Knowing the algorithm "0x5F3759DF" (or "fast inverse square root"), we easily imagine a gross number of variants of it to calculate square root and inverse multiplicative of it in single-Precision…
-
0
votes1
answer748
viewsEfficient method for comparing lists
I have a problem where I need to compare Strings and define their proximity. The problem is that I have a list with 21,000 records and I need to compare them all, with each other, which would give a…
-
0
votes1
answer147
viewsImprove Process Performance C#
Good morning, I have a problem of slowness when performing a process that is performed 1 Insert and 2 Updates for each record. That is 2500 records, will be held 7500 access in the database. Here is…
-
0
votes1
answer429
viewsReact Native application performance built with Expo
I am developing a mobile application using React Native through the Expo but I have been finding a small "problem". I use my physical device (android) to carry out the tests through the Expo…
-
0
votes1
answer73
viewsIn C language working with strings would it be better to spend processing or memory?
In general in programming it is better to spend resources on processing (calculations) or memory (creating variables)? Contextualizing: I am developing a solution for a program that uses struct and…
-
0
votes1
answer231
viewsQuestions about using the GUID type instead of int
I see many models of systems on the net where Id fields are set with GUID type instead of INT, as in the example below: public class Product { public Guid Id { get; protected set; } public string…
-
0
votes1
answer47
viewsBest Script Performance
I made a condition that way: If @dt_contabilizacao = @dt_operacional And Not Exists (Select 1 From tabela Where dt_mes_referencia = @mes_referencia) But the check of dt is not necessary since if…
-
0
votes1
answer57
viewsPerformance issues with Asp.Net Core 2.1?
I have an API written in Asp.Net Core 2.1 and I have some performance problem, I am not able to understand if the problem is in the code or the server. The problem boils down to the following, I…
api performance iis entity-framework-core asp-net-coreasked 4 years, 1 month ago Renner Oliveira 23 -
0
votes0
answers44
viewsRelationship between performance and scalability
I was facing problems to carry out the maintenance in a code of my own, due to the extensive and little defined classes (grew a lot over time), to simplify the question I will divide the time line…
-
0
votes1
answer2428
viewsCalculate execution time of a sort algorithm in C
I have a question about how to get the run time only in the sort algorithm. I searched a lot on the Internet and found a lot of superficial stuff, nothing that would help me in what I need. I have a…
-
0
votes0
answers45
viewsComplexity of Strand Sort algorithm
I’m using the Strand Sort to do a college job and wanted to know if at level of complexity, in worst case it O(n 2). and I wanted to know under what circumstances it would be better to use this…
-
0
votes1
answer42
viewsHow much can the access cost of an unodered_map hinder the performance of a game?
The cost of access to unordered_map can cause FPS to drop in a game if it is accessed thousands of times per second? class var { public: template < typename t = double > static inline auto…
-
0
votes1
answer322
viewsHow to test the execution time of a code in Visual Studio 2017?
I’m trying to test the execution time of a code, but I’m always getting incorrect values, the first test will always be the one with the worst time. And most of the time the second test is always 0.…
-
0
votes2
answers121
viewsArithmetic operations in PHP or Mysql?
What would be the good practice when doing arithmetic operations that come from a database query, for example: SELECT valor_bruto_atual, valor_investido, (valor_bruto_atual / valor_investido) AS…