Questions tagged as 'rendimiento'

4
answers

Declare array inside loop vs empty it on each loop

I wonder if in C / C ++ it is better to declare a new array every loop loop: while(true) { char array[255] = ""; // Hacer algo con el array ... } Or empty it every turn of it: char array[255] = ""; while(true) { for(short i = 0; i...
asked by 09.04.2016 / 19:36
1
answer

Efficient Query Group by, Having - SQL Server

I have the following query : SELECT S.IdCliente ,S.NOMBRE ,S.JLI_SDESLINEA ,S.JCA_SDESCATEGORIA ,SUM(S.MONTO) AS MONTO ,COUNT(*) AS QTY ,S.DIA ,T.IDTERRITORIO ,T.VENDEDOR ,T.SUPERVISOR ,V.IDCLIENTE FROM...
asked by 10.08.2017 / 23:53
4
answers

Optimize a query with a repeated subquery of MySQL

I have the following query SELECT * FROM TABLA_A WHERE CAMPO_1 IN ( SELECT CAMPO_X FROM TABLA_B ) OR CAMPO_2 IN ( SELECT CAMPO_X FROM TABLA_B ) The query works, I hope you can optimize the call of in since they are equal. I have...
asked by 28.09.2016 / 00:39
3
answers

Improve Performance Nested Foreachs

I have 2 foreach nested of a class articles, in which I go through two lists, and if the item in list 1 is in list 2, it must do a couple of operations, the dilemma is that when dealing with very long lists, it takes a long time and I nee...
asked by 04.07.2017 / 04:10
2
answers

Many-to-many relationships postgrest, consultation to take out in a single row

I have a table A : ----------------------------- | id | nombre | cel | ----------------------------- |1 | Juan | 1653727| |2 | Pedro | 6353526| |3 | Hernan | 4465672| ----------------------------- Another ta...
asked by 03.06.2018 / 20:58
0
answers

concurrency problem Wildfly 10 Primefaces 6 in com.sun.faces.lifecycle.RenderResponsePhase / doPhase [closed]

I have developed a JEE application with primefaces 6 Spring in Wildfly 10. The application works well with few users, but from 10 users the system starts to give very high response times of more than 10 seconds. With 25 User gives times of 30...
asked by 04.04.2017 / 23:17
1
answer

Qt and Linux - QGraphicsItems with low performance

I'm having performance problems with the painting in Qt and the QGraphicsItems in Linux. It gets very "locked" when I add things to the painted (grillas and others). I put a qDebug in the paint to see which area is drawing: void...
asked by 13.06.2018 / 14:41
2
answers

Performance problem with background-image

My case is that I am developing a web of musical artists and had the idea of showing a page with several div whose backgrounds are photos of the different artists and when the mouse passes have the animation of a box-shadow showing the name of t...
asked by 06.08.2017 / 14:14
1
answer

Change sql query

I have the following query to obtain an average of some data of the 52 weeks of the year in the following way: $dates = array(); $firstDate = date("Y-m-d", strtotime('first day of January 2016')); $lastDate = date("Y-m-d", strtotime('last day...
asked by 03.02.2017 / 20:42
0
answers

JavaFx Finder [closed]

To search a TableView that uses filtered or directly in the sql statement.     
asked by 19.12.2016 / 23:13