Questions regarding lenght() function

[Ruslan Zasukhin]

On 31/3/07 1:28 PM, "Thorsten Hohage" <thohage at objectmanufactur.com> wrote:

>> In "worse case" you can try create Table Method (virtual field) and
>> use it for ORDER BY.
>> 
>> This also is good BECAUSE you can mark this field as Indexed, so  Valentina
>> will build INDEX for length() result. And this speed up query a lots.
> 
> In worst case THIS breaks a lot of legacy sql92-code and forced me to
> maintain two different set of scripts / sql-queries :-)
> 
> As written in another thread, it's nice to have "things" to speed up
> valentina and is good to know them. But on another hand I want to
> have a decision between sql92-cross-database-without-a-thought or
> burning-fast-in-valentina-only

No doubt -- we are moving to full support of SQL Standard.
Its the target.



-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]