Valentina or other database???

[Claudius Sailer]

Hi,

best possibility to get an answer is to ask on  
Valentina-Developer-List. Support is great and fast.
I believe Ruslan will be able to give you some hints to speed up.

bye


Claudius


Am 06. Sep 2004 um 18:00 Uhr schrieb Aldwin Pollefeyt:

>
> I have a table with 65000 records with each 250 values. (G4PPC 800Mhz-  
> 512MB SDRAM)
>
> The fastest way that I found now with a Valentina Database is :
>
> RowFromFile=l.readline
> FirstRowFromFile=replaceall(RowFromFile,chr(9),chr(44))
> do
>   RowFromFile=l.readline  '250 values
>    testSQL=SQLExecute("INSERT INTO "+SQLTable+" ("+FirstRowFromFile+")  
> VALUES  
> ('"+ReplaceAll(ReplaceAll(RowFromFile,chr(39),chr(92)+chr(39)),chr(9),c 
> hr(39)+chr(44)+chr(39))+"')")
> while not eof '65000 Records
>
> 1 insert = 500ms  =>  65000 * 500ms = 32500s => 541m 40s => 9 hours
>
> without the insert (with readline, replaceAlls, ....) => 1 record < 1  
> ms
>
> :(  Luckely this is the biggest table but there are others also for a  
> few hours.
>
> Greetings,
>
> Aldwin
>
> Started with RB on the 7th of June 2004
>
> _______________________________________________
> Unsubscribe or switch delivery mode:
> <http://www.realsoftware.com/support/listmanager/>
>
> Search the archives of this list here:
> <http://www.realsoftware.com/listarchives/lists.html>
>