Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 2 of 2 total |
Select query hangs |
Tue, Dec 18 2007 4:23 AM | Permanent Link |
"M. Malagoli" | Hi,
i have a strange problem with this query SELECT filedati.idx, suoni.idx, suoni.nome AS nomeSuono, suoni.dimens, suoni.descriz, suoni.idTipoSuono, suoni.sampleHz, lksuoni.idSuono, lksuoni.idFile, lksuoni.posSuono, tiposuono.nome AS descTipo FROM filedati, suoni, lksuoni, tiposuono WHERE lksuoni.idSuono = suoni.idx AND suoni.idTipoSuono = tiposuono.idx AND (lksuoni.idFile = filedati.idx OR :Pidx = 0) AND lksuoni.idFile = :Pidx ORDER BY lksuoni.posSuono If execute query: Pidx != 0 -->OK Pidx = 0 -->Hangs If i try in ElevateDB Manager: Pidx != 0 -->OK Pidx = 0 -->OK Any suggestion? thanks |
Tue, Dec 18 2007 3:36 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | << i have a strange problem with this query >> It's either one of two things. There is an issue with 1.06 in terms of parameterized queries that return an insensitive result set not completing due to the change detection constantly kicking in. The other issue is that your query is using SQL-89 joins, which EDB does not optimize. You should use SQL-92 joins instead with the INNER JOIN statement. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |