I currently have a table with about 6 million records that in turn perform a lot of I / O operations, so in designing the project I chose to use InnoDB instead of MyISAM in MySQL, after all, lock would be per page, not per table.
But I ha...
I worry about the final performance of an executable at the same time, I do not want to penalize the programmer with excessive or unnecessary care in the code.
In the code below, for example, it will return the same value as the getPositio...
I'm passing SonarLint on a somewhat old application and fixing several "problems", but I came across a code snippet like:
public void fazerAlgo(final String param) {
MeuObjeto m = new MeuObjeto();
m.setVar(param.toLowerCase());
m...
The View 's are virtual tables, resulting from SQL queries, as in the example:
CREATE VIEW view_name AS
SELECT column_name(s)
FROM table_name
WHERE condition
From this, we can update or delete a View , but we can not edi...
I have MongoDB running on a 500GB SSD.
But as the folder / data began to get very large, we put a 3TB HD slave , but this being SATA and not SSD as the first.
But after changing the folder date to this new HD, we noticed a considerable di...
Let's say I have these namespaces :
use
DataTables\Editor,
DataTables\Editor\Field;
DataTables\Editor\Format,
DataTables\Editor\Mjoin,
DataTables\Editor\Options,
DataTables\Editor\Upload,
DataTables\Editor\Validate...
I'm using EasyPHP 14.1 Devserver , which comes with Apache 2.4.7 / MySQL 5.6.15 .
I want to simulate high traffic and concurrent access to observe the performance and behavior of my site under these conditions, to make the...
I know 4 different types of concatenation of string in C #:
// string Interpolation
$"valor {variavel} R$";
// Verbating string
@"texto qualquer
pula a linha e continua o texto";
// concatenar 2 strings
"texto" + "texto";
// string.form...
Is there a difference if I use:
select *
from a left join b on a.id = b.id and b.id2=1
where ...
or
select *
from a left join b on a.id = b.id
where
b.id2=1
Sent on:
Fri
?
The first SQL returned me super fast, the second one did...