Questions tagged as 'desempenho'

Tagged questions
3
answers

Many tables with few data or few tables with lots of data? [closed]

I have a bank that will receive a lot of data. I am in doubt whether it is better to organize the data into a few tables with too much data or to split the data further into multiple tables. In which case will the queries be faster? I'm using My...
asked by 10.10.2016 / 13:10
2
answers

Which is faster: NULL or NOT NULL (with an empty string)?

I have a table with NOT NULL fields and they end up empty. What is the difference between a NULL (allows null values) and NOT NULL with an empty string ( '' ) inside?     
asked by 28.06.2018 / 17:28
2
answers

Why does the universal selector * have a negative impact on browser rendering?

I was going to apply a CSS Reset on my website. I usually use Eric Meyer's link . But I was looking at the suggestion of Diego Eis in link that is like this: * { margin:0; padding:0; list-style:none; vertical-align:baseline; } I found it...
asked by 06.08.2014 / 15:01
2
answers

UPSERT or UPDATE-INSERT?

Through this question I felt the need to research and understand a little about the UPSERT . I was wondering what a blessed command this is? I never saw .. I found some information but it is still not clear to me because there is no "basi...
asked by 23.08.2018 / 13:16
1
answer

Pass complex object vs simplest object per parameter

In the Log method there is the parameter of type HttpClient . The function only uses the parameter to access the property BaseAddress , which is a Uri . private void Log(string verb, HttpClient httpClient) { var ur...
asked by 09.11.2017 / 18:57
1
answer

Increase PHP / MySQL script performance

Good Afternoon Currently, I have a script in PHP that leads a CSV file of 6801 lines, and performs an INSERT as long as there are records. I'm currently able to insert 19 records per second. In addition to this INSERT routine that runs eve...
asked by 17.07.2015 / 21:44
3
answers

What is the best option to use in relation to performance

I need to make all products add up from the screen, but I have products that are no longer on the screen. So my question is: Will it be that if I hide only the products that are visible will it perform better? instead of giving .hide() to...
asked by 03.07.2015 / 16:15
3
answers

SUBSELECT vs. INNER JOIN

Is there any recommendation on which of the two is preferable in terms of performance? SELECT funcionarios.nome FROM funcionarios INNER JOIN empresas ON empresas.id = funcionarios.empresa_id WHERE empresas.nome = 'Nome da Empresa' or SE...
asked by 30.06.2014 / 13:35
2
answers

Can a worse-cost query be a better-performing query?

Context Here in the company we have a very complex query that encompasses several business rules, for presentation in a WorkFlow and for now I am evaluating it in SQLServer . The performance of this query was poor and as the tables grew,...
asked by 25.09.2014 / 22:59
2
answers

Database model optimization

I'm making a system for a college and one of the subsystems I'm building is the student newsletter. I put it to when creating a new discipline in the table "discipline" this discipline is added to the "notes" table with a record for each id of e...
asked by 08.10.2017 / 19:11