From: Claudio V. C. <cv...@us...> - 2001-12-12 01:29:59
|
> -----Original Message----- > From: fir...@li... > [mailto:fir...@li...]On Behalf Of Brad > Clements > Sent: Martes 11 de Diciembre de 2001 17:09 > > It's still quite slow (over 60 seconds to run on a PIII-733). Do you think > there's a more efficient way to express this? - First, some wrong reports against ambiguity were removed in RC2. I can't claim that's perfect, however. - Second, if you declare an alias, use it. In your example, you declared S, but didn't use it. Now it's applied: select charges.id from charges inner join shipment s on (charges.shipmentid = S.shipmentid ) where (charges.chargetoorg = 'cw' and S.shipdate >= '2001/11/01' and S.shipdate <= '2001/12/10' and S.invoicenumber is null - Third, use IB-Support, please. It's our first line of defense to isolate bugs against typical known problems. - Fourth, if you like to delve into performance, read here, those updates will run much faster when converted to use db_key: http://www.cvalde.com/document/mysteriousDbKey.htm C. --------- Claudio Valderrama C. Ingeniero en Informática - Consultor independiente http://www.cvalde.com - http://www.firebirdSQL.org |