Seems like your DB is simply not responding inside your specified time limits.
Try generating the SQL for that query and running it by hand ;-) Marco Pivetta http://twitter.com/Ocramius http://ocramius.github.com/ On 11 June 2015 at 00:18, Ualison Aguiar <[email protected]> wrote: > 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. > -- 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.
