Stan, Claudius, your feedback on fc1 ?

[Ruslan Zasukhin]

On 12/27/05 9:41 PM, "Claudius Sailer" <Claudius at sailer-online.de> wrote:

> V4RB1.10

> Results in sec FIRSTPART / SECOND PART / THIRDPART
> 
> 0,78 / 0,03 / 1,43
> 0,70 / 0,05 / 1,31
> 0,81 / 0,05 / 1,40
> 0,73 / 0,06 / 1,30
> 0,71 / 0,05 / 1,23
> 
> 
> V4RB2.1fc1

> Results in sec FIRSTPART / SECONDPART / THIRDPART
> 
> 0,000 / 1,30 / 1,43
> 0,016 / 1,11 / 1,56
> 0,030 / 1,05 / 1,38
> 0,016 / 1,53 / 1,08
> 0,030 / 1,06 / 1,06

Claudius,

Do I read this correctly:

* first column -- V2 wins. And Hmm, it wins A LOTS ?

        0,700 / 0.016 = 43 times faster ?
        0,810 / 0.030 = 27 times faster ?

* second column -- V2 is slower of V1 about 40 times.

* third column -- speed comparable..


So we need check your UNION query to see what we can speedup...


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