optimize the "SELECT" requests in Valentina

[Charles Yeomans]

On May 22, 2004, at 7:07 PM, Ruslan Zasukhin wrote:

> 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.

Yes, it appears the the important optimization is to choose Valentina.


--------------
Charles Yeomans