SQL request and speed ? III

[Claudius Sailer]

Hi Thierry,

do you inserted an request in Mantis?
What number?

Thanks

Claudius

Am 30. Okt 2005 um 12:09 Uhr schrieb Thierry Nauze:

> Hello Ruslan,
>
> For a rudimentary request :
>
>   for i=1 to 10000
>     call baseValentina.SqlExecute( "INSERT INTO maTable  
> (id,maVarChar) VALUES ("+str(i)+",'A')" )
>   next
>
>
> RealSQL is always 8 (even 10) time faster than Valentina 2.11  :   
> 0.45 s  vs 4.87 s !
>
> I had sent you an example of program before the exit of the version  
> 2.05...
> Nothing changed !
>
> Is it necessary to avoid the use of the SQL with Valentina 2 ?
>
> Regards,
>
> --
> Thierry NAUZE        Saint-Denis de la Réunion
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>

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