Stan, Claudius, your feedback on fc1 ?

[Ruslan Zasukhin]

On 12/28/05 10:55 PM, "Claudius Sailer" <Claudius at sailer-online.de> wrote:

Hi Claudius,

> it is much much slower as solution with UNION and UNION ALL

This is not clear to me.

So you use THE SAME way as with 1.x version ?
Then fact of RAM table should give you speedup

 
>    meineDatenbank.Table( "TempAnzeige" ).DeleteAllRecords(NIL)
>    SQLString=SQLBuilder(47,false,cstr(AktuellesKonto)) //Ausgaben
>    cmd= "INSERT INTO TempAnzeige (Buchungs_ID, BDatum, Gegenkonto,
> Kategorie, Ausgabe, Einnahme, Kommentar, Blocked) "
>    cmd=cmd + SQLString
>    count=V4RBSQLExecute(meineDatenbank,cmd)
>    SQLString=SQLBuilder(48,false,cstr(AktuellesKonto)) //Einnahmen
>    cmd= "INSERT INTO TempAnzeige (Buchungs_ID, BDatum, Gegenkonto,
> Kategorie, Ausgabe, Einnahme, Kommentar, Blocked) "
>    cmd=cmd + SQLString
>    count=V4RBSQLExecute(meineDatenbank,cmd)
> 
> 
> it takes 1,2-2sec for this code. With UNION ALL I don't have RAM-
> Table and it is 0,8-1,1sec with my known coding


Btw, how big is your db? And how many records are in result ?

If you want send us project that test this 2 queries.


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