Questions tagged as 'desempenho'

Tagged questions
1
answer

Doubts about using GUID type instead of int [duplicate]

I see many models of systems on the net where Id fields are defined with type GUID instead of INT, as in the example below: public class Product { public Guid Id { get; protected set; } public string Name { get; protected set;...
asked by 18.04.2018 / 18:13
1
answer

Improve Process Performance C #

Good morning, I have a slowness problem when performing a process that is performed 1 Insert and 2 Updates for each record. In other words, 2500 records, 7500 access will be carried out in the database. Here is my doubt of how I can improve this...
asked by 06.04.2018 / 15:53
0
answers

Where is it best to store sessions? [duplicate]

Would you like to know the best way to store sessions? In memory; On disk; In cookies; In database. Which of the above is best and why?     
asked by 24.03.2018 / 22:38
1
answer

Efficient method to compare lists

I have a problem where I need to compare strings and define their proximity. The problem is that I have a list with 21,000 records and I need to compare all of them with each other, which would give a quadratic complexity and in total would b...
asked by 20.03.2018 / 15:18
0
answers

Slow to generate report with report viewer

Problem description: I'm having trouble slowing down reporting with a "large" volume of data in Report Viewer 2015. When I generate a report with 5600 records in pdf format, it takes about 35 seconds to display the report, and although I...
asked by 15.03.2018 / 15:04
0
answers

Upload and Insertion Performance Test

I'm new to the performance test scenario. I have to do a performance test on a web system (use Spring and Angular ) where it uploads a file with several entries on each line. I have to use JMeter to do this test. What is happening is as...
asked by 22.02.2018 / 13:27
2
answers

Left join or Sub-Select? Which one has the best performance?

I'm studying which of the querys below would perform better. So I wrote both and ran on the same database with the same data: Query 1: select a.numeroOp as OP, a.codigo as CÓDIGO, (a.qntAhProduzir + a.qntPara...
asked by 05.02.2018 / 18:32
0
answers

How to increase the performance of a search with for

Basically the program I did does this same procedure, but with more data. I need to increase search performance, of course this can be done with libraries if that is better. No matter how performance improves, as long as the data format stays th...
asked by 02.02.2018 / 15:37
0
answers

Multimedia file storage

How does the storage of multimedia files for the main DBMS work? How does the return of this data work in terms of performance? Technical specifications of one served to store a large amount of data.     
asked by 23.01.2018 / 13:42
0
answers

Query Performance - HELP

I'm doing a query , however I'm learning now. Can you improve the performance of this query? select a.COD_EMPRESA, b.Dat_pagamento from SAS_EMPRESA a full outer join SAS_ITEM_PAGO b on (a.COD_PREF_EMPRESA || a.COD_EMPRESA = b.COD_PREF_EMPRESA...
asked by 17.11.2017 / 19:28