El Jueves 05 Abril 2001 04:10, escribiste:
>
> You would probably have better luck if you cast the date restriction
> as a range, for example
>
> where fecha_factura >= '2001-03-01'
> and fecha_factura < '2001-04-01'
True
It runs 10 times faster !!!
You are a genius ;-))
Thanks
"J.Fernando Moyano" <[EMAIL PROTECTED]> writes:
> The execution time of certain queries is 20 or 30 times longer in 7.0.2 that
> 6.5. (20 or 30 seconds where before it was 1 or 2 seconds !!!)
Have you done a VACUUM ANALYZE?
Other than that, there's no generic advice. You'll need to provide som
