optimize the "SELECT" requests in Valentina

[Ruslan Zasukhin]

On 5/22/04 10:12 PM, "olivier" <vidal_olivier at yahoo.fr> wrote:

> Hi,
> 
> The advices (to improve the speed of the SQL requests) what one reads
> in SQL books are  they applicable for Valentina?
> 
> Ex:
> 
> - Not to use "*" in the requests SELECT but the names of columns "
> Column A, column B.... "


Yes
 
> - " ORDER BY " is often slow

Of course, but usually you want data sorted

> - Use "BETWEEN" instead of "AND" when it is possible

Not big difference


> To use short names of column  (ex: "TypPS") instead of long names of
> column (ex: "Type_Price_Sales") is faster in Valentina?

Well, yes. A little

> More generally, you have advices to optimize the "SELECT" requests in
> Valentina?

Frankly saying above tips give a little speedup if any.

I think main work Valentina do self.


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------