Stan, Claudius, your feedback on fc1 ?

[Claudius Sailer]

Am 28. Dez 2005 um 10:00 Uhr schrieb Ruslan Zasukhin:

> On 12/28/05 7:09 AM, "Claudius Sailer" <Claudius at sailer-online.de>  
> wrote:
>
>> when you now say that UNION is much much slower than filling other
>> table with 2 SQL-Statements and reading from this table I will check.
>> Or do you wants to tell me too that UNION ALL could be a Solution?
>
> This can be a case. Please check.
>
> As I understand your app did logic of UNION ALL.
>
> In any case we will try check this type of query to see if and  
> where problem
> exists

UNION ALL is 20% faster. One more big step.

thanks

but I will test tmpTabpe too during next days....

bye


Claudius

-- 
G4/733 QS / MacOS X 10.4de / RB 2005r4/ Valentina 1.10.0 & 2.0.4
Homepage    http://www.ClaSai.de
iChat        ryhoruk
RealBasic ListBoxes: [ I feel the need...the need for speed!!! ]