desempenho

How to reduce the search time in a table with more than 200 thousand records?

I'm trying problems for listing and searching data in table with more than 200 thousand records. I read in searches, that fo ... JOINS to display the results on the screens. Now I need to think of a way to replace the JOINS and display the same results.

Cast or direct cast functions. What is the best option?

In PHP, I realize that it is possible to do some things in countless ways. One of them that has come to my attention are the ... calling a constructor, is there a situation that you will actually need to use type conversion functions, rather than cast?

How does PHP-FPM work?

Guys, I have a question related to the concept of PHP-fpm . From what I understood through the documentation, it is a module ... P that manages the requests to the server to avoid high loads, or am I mistaken? How can it benefit in terms of performance?

Data concatenation or sequencing: which performs better?

A few days ago I was writing some articles about PHP, in which I was asked about a possible performance improvement in large ... a function. Therefore, if you want to pass more than one parameter to echo, the parameters do not need to be in parentheses.

Why multiplication is faster than division?

Bit brushing question, but I was reading an article on javascript where it says division is slower than doing multiplications ... e article I mentioned in Section Math : http://jessefreeman.com/game-dev/intro-to-programming-for-games-with-javascript /

How to make my program consume less CPU without disrupting its execution?

I have a program that reads the memory of a computer process continuously (with the while (true)), but this ends up requiring ... eep(3000, 200); one = !one; } } Summary: mem.Read reads the memory of a process. DrawGlow() write in memory.

Which is more efficient, perform multiple queries or use JOIN?

I have a table X that has my user's data, and I need to return to the client the data related to that user in the table Y and ... g JOIN or: SELECT attr1, attr2 FROM Y WHERE X_id = id SELECT attr1, attr2 FROM Z WHERE X_id = id Which is more efficient?

Is there a performative difference between Tuple and List?

In Python, I know there is the difference between a Tuple and a List. Tuple is immutable, and List is changeable. Even you a ... than the other. The Tuple, because it is immutable, can generate more performance/performance than if it were to use a List?

What can cause the EF performance drop in this scenario?

I've been doing a data import for a project in ASP.NET MVC 5 with EF 6.1 and SQL Server 2008 where the import data source w ... d; } else { profissao_id = profissaoTemp.Id; } } return profissao_id; }

When to use "inline"?

Everyone says they don't need to use inline in functions since the compiler knows what to do better than the programmer. But if you have it in the language, it should be good for something. Is it useful in any case? When to use then?

Is there a problem with the existence of duplicate CSS, but 100% the same?

I own an application, where I have a file called "layout" which is responsible for displaying all HTML (head, footer, body ju ... ese pages and leaving only in the default CSS file. Can this duplicate CSS result in some performance issue or other issue ?

Is it always guaranteed that an application with multiple threads runs faster than using a single thread?

It can be observed in some cases that the separation of tasks in multiple threads gives no gain and even makes an applicatio ... ation when there is only a processor (or core) on the machine? You can parallelize any task and get gain from performance?

Unnecessary indices in the bank are a problem?

It is common to add indexes to improve query performance. But usually it is not recommended to leave by adding indexes in eve ... at is column, only where the need is identified. Why this recommendation? What kind of unnecessary index problems can cause?

SUBSELECT vs. INNER JOIN

Is there any recommendation on which of the two is preferable, in terms of performance? SELECT funcionarios.nome FROM funcio ... rios WHERE empresa_id = ( SELECT id FROM empresas WHERE nome = 'Nome da Empresa' )

Minify HTML code

It is normal to see minified JavaScript files for performance gain. Today we see some sites that minify everything, includin ... st? If the site is not available, the minification I mean, is to simply remove the spaces, and not "transform" the code.

Difference between absolute and relative URLs in page contents

The contents of the page can be requested by entering a full URL, relative or relative to the root of the location where our ... g any of the three options we have at our disposal? clear that we have a reduction in the amount of code, but beyond that...

Using unused affect performance?

While developing, I saw that in a large part of my classes contained a certain amount of using that were not being used and I ... ing unused affect application performance in any way? Do you always have to remove unused ones or will it make no difference?

How to optimize this function for Fibonacci sequence?

On the site codility there is an initial challenge for you to refactor this Code: var yourself = { fibonacci : functio ... rect value, but the execution takes too long. Improve it!). The question is, what are the other ways to do this calculation?

What is the difference between drawing in Activity and fragment?

After the latest SDK update in Eclipse, when you create a new project, you also create a fragment next to activity_main. I wo ... ated, since before it opened directly to activity_main. Is there any difference in the performance of the project? Thank you

How to improve file write speed for a ClientDataSet?

I'm integrating a system with a bank file, and I'm having a problem in the process. I receive from the credit card operator a ... Inc(TotalRegistrosCV); end; end; So, any idea how to streamline this process? Or a better way to carry out this process?