Postgres Pro
Downloads
Home   >   mailing lists

Re: very very slow ..... - Mailing list pgsql-sql

From J.Fernando Moyano
Subject Re: very very slow .....
Date
Msg-id 01040602362600.01608@txino.mikasa.eh
Whole thread Raw
In response to very very slow .....  ("J.Fernando Moyano" <txinete@wanadoo.es>)
List pgsql-sql
Tree view 
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 !!

-- 
Fernando Moyano

Frase del día:
--------------
Yo antes era vanidoso, pero me cure, y ahora soy perfecto! O:-)

(*) SymeX ==> http://symex.lantik.com
(*) WDBIL ==> http://wdbil.sourceforge.net
(*) Informate sobre LINUX en http://www.linux.org

pgsql-sql by date:

Previous
From: Keith Gray
Date:
Subject: Re: Index on View ?
Next
From: "guard"
Date:
Subject: get all online user?