Questions tagged as 'desempenho'

1
answer

What criteria should be analyzed in the language choice for creating an application? Performance is everything? [closed]

I need to create an application that is the source of communication between several other applications with the database, that is, other applications will make requests for this application that will be created, and it will have a duty to relate...
asked by 06.04.2017 / 00:23
1
answer

How much each function "costs" to the server

My question is regarding the is_dir function to check for a directory. How much does it cost to use this function? How to measure the use of this or another function in PHP? The file_exists function, for example, says it costs 12 ti...
asked by 27.03.2018 / 05:04
2
answers

What is the best way to query SQL Server database using a list entry?

I have a question as to how best to approach the following problem: I need to query records in a SQL Server table using a list of serial numbers. I know the IN command, but it does not answer because it is limited to receiving a maximum of 2100...
asked by 13.01.2015 / 13:35
3
answers

Memory and processing - Variables and verification

Is there a big difference for memory and processing in how to run the check in these two examples? If yes, why and how both behave at the time of executing the codes. Method 1: var exam = FindExamByID(id); if (exam == null) { return No...
asked by 10.08.2017 / 16:13
2
answers

What is the best method to access a member of a class?

What is the best method to access a member of a class in terms of speed and organization? class cMinhaClasse { public: void Funcao(int r); }; int main() { // Método 1 - Acessando classe por ponteiro cMinhaClasse *mClasse = new cMi...
asked by 22.09.2017 / 18:55
1
answer

Use specific data types like SMALLINT and MEDIUMINT instead of INT and mark columns with UNSIGNED is an exaggeration?

Speaking of databases, we know that they have several data types to use in each specific situation. But, following the data types to the letter can be considered an exaggeration in most cases or is it always recommended, even giving more work to...
asked by 05.06.2017 / 02:29
1
answer

Cost of processing between code and database

Among the many forms of development, there was a doubt about what will consume more of my processing between the same operation in different ways ... If I have a function that can be done directly in my database (a insert using a se...
asked by 27.04.2017 / 20:55
1
answer

Improve search performance when there is no record

I have a database with 9551011 rows. It contains addresses from all over the country. When I make a query for a certain place, and that address exists in the database, I get a return in a maximum of 2 seconds. The problem is that this bank is...
asked by 01.09.2016 / 18:38
1
answer

What better way to solve slowness to generate report?

At one time, I developed a page of reports, the users have a filters option, this is working, but as the data in the database are growing it is getting slower and I do not know which option is best to solve this problem, some of the things I tho...
asked by 09.09.2016 / 20:32
1
answer

Logical deletion of SQL Server records

We have the culture to only make logical exclusions in the application, maintaining 2 fields where 1 is the deletion date and another one that receives 'S' or 'N'. When we perform searches for undeleted records, we do something like: select...
asked by 13.02.2015 / 00:52