Hello everyone good night,
I have a following problem when using createQueryBuilder in Oracle Database
11g.
Follows the assembly of the query:
$queryBuilder = $this->getEntityManager()->createQueryBuilder();
$strCampos = 'COUNT(' . $this->getAlias() . '.idArquivo)
qtRegistros, Transacao.coTipoSituacaoTransacao coTipoSituacaoTransacao';
$strDqlQtPagamento = $queryBuilder->select($strCampos)
->from($this->getEntityName(), $this->getAlias())
->innerJoin(
'Participante\Entity\ArquivoDetalhe',
'ArquivoDetalhe',
'with',
'ArquivoGruDetalhe.idArquivo = ' . $this->getAlias() .
'.idArquivo'
)
->innerJoin(
'Participante\Entity\Transacao',
'Transacao',
'with',
'Transacao.idArquivoGruDetalhe =
ArquivoGruDetalhe.idArquivoGruDetalhe'
)
->where($this->getAlias() . '.idArquivo = ' . $intCoArquivo)
->groupBy('Transacao.coTipoSituacaoTransacao')
->getQuery();
Entity in the transaction table have 88,450 records in the information
environment and the system does not return runtime execution occurring
overflow.
I identified that the call of the execute method of the class
doctrine/dbal/lib/Doctrine/DBAL/Connection.php line: 824 of the
executeQuery method and responsible for the delay.
When I run the same code in the development environment where you have no
more than 100 record does not present the scenario occurred in another
environment.
Could anyone help me identify the reason.
I performed some scenario, when do not use the bind on condition right past
the value, problem does not happen in the information environment.
Follow the composer data regarding the doctrine:
"doctrine / annotations", "> = 1.0"
"doctrine / doctrine-orm-module": "dev-master"
thank you
--
You received this message because you are subscribed to the Google Groups
"doctrine-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/doctrine-user.
For more options, visit https://groups.google.com/d/optout.
