Questions tagged as 'desempenho'

1
answer

LEFT JOIN with WHERE in the field of the first table OR field of the second table

SELECT COALESCE(tb2.numero_novo, tb1.numero_original) as numero FROM tb1 LEFT JOIN tb2 ON tb2.id = tb1.id WHERE tb1.numero_original = <PARAM> OR tb2.numero_novo = <PARAM> The above query generates a full table scan. How to optimiz...
asked by 27.05.2015 / 19:56
1
answer

What is the most efficient way to remove an item from the ArrayList? [closed]

I would like to know which of the methods available by class ArrayList is most efficient for deleting an item from the list.     
asked by 27.05.2017 / 23:11
1
answer

Is the Node server the only option to support the maximum level of requests in an application?

For an application project that will need to support a huge amount of requests on the server such as an e-commerce portal on the day of black friday or the server of a game developer on the first day of launching an ultra-long-awaited game t...
asked by 18.10.2018 / 18:00
1
answer

When to use a scripting language? [closed]

When to use a script language and what is the ideal scenario for using it? I have read about script languages and thought about using them in my C / C ++ server project for one game, which leads me to another question: I know it depends a...
asked by 06.12.2016 / 23:41
2
answers

MYSQL - Column Order and Performance

I may be asking a silly question, but come on. Does the order of columns in MYSQL interfere with performance in any way (either in writing or in research)? Foreign keys are at the beginning or at the end, the fields type TEXT...
asked by 30.06.2015 / 21:02
2
answers

In terms of performance, "character varying" or "text" in PostgreSQL?

Before posting this question I searched the internet to know the differences and performance of each type and I came to the conclusion that I should discuss a little more about this subject here with the experts, rs, I already know the differenc...
asked by 28.11.2017 / 12:26
1
answer

Time difference in execution of the same query between PHP and PHPMYADMIN

I'm trying to improve the performance of my pages to improve the user experience, but I'm not able to identify the problem. According to Google, it is recommended that pages respond in less than 0.4 seconds, but only the connection to the dat...
asked by 19.07.2016 / 15:27
2
answers

Method change entity code [closed]

In a client in Mozambique I need to change entity code and use the PRIMAVERA API method _erpBs.Comercial.Clientes.AlteraCodigoCliente(codigoAntigo, codigoNovo); The problem is that this method has high performance costs, some suggestions fo...
asked by 21.06.2018 / 11:30
1
answer

Matplotlib (Python) slow to plot a 2-D chart?

I have recently come up with the need to use Python to plot graphics with more than 3600 coordinates, but I realized that time may be a problem, but I'm not sure if the code I've done has a performance problem or if it's from the same library:...
asked by 22.03.2018 / 00:09
1
answer

How to have performance in systems? [closed]

How does the issue of performance in software, websites, etc. work? Facebook transpiled PHP into C ++ to gain performance. How does it work? I know with C ++ to set exactly the variables, but does the performance depend on the language, p...
asked by 04.02.2018 / 00:19