Table structure?

[Joakim Schramm]

> -----Original Message-----
> From: valentina-bounces at lists.macserve.net 
> [mailto:valentina-bounces at lists.macserve.net] On Behalf Of 
> Ruslan Zasukhin
> Sent: 29 April 2006 21:32
> To: valentina at lists.macserve.net
> Subject: Re: Table structure?
> 
> On 4/29/06 10:23 PM, "Joakim Schramm" <joakim at astrocalc.com> wrote:
> 
> >> I must do something wrong, import of data crashes after about 80% 
> >> with automation error, it's on AddRecord call. Also, the 
> data which I 
> >> read from text files occupy 11Mb on disc, but on scrash 
> the db .dat 
> >> file is 333Mb!
> >> 
> > Aha end of the 400+mb logfile says
> > VTable.AddRecord...
> > PARAM: this = 25451568
> > ERROR: 0x99520 Demo-version time limit reached
> > 
> > But error message say Automation error, Catastrofic! 
> Valentina wasn't 
> > fast enough :-) Well it's not only her...
> 
> :-) Let's see how speed up it.
> 
> 1) set bigger cache size. E.g. 20-50 MB
> 
How much is InitValentina 9 * 1048576, is it 9 Mb? I have 2GB so I guess
there are some to spare :-)

> 2) make sure that you DO NOT make flush() after each AddRecord().
> 
I don't flush at all, not yet, as I have much memory.

> 3) Ohhhhhhh!
> 
>     and set OFF this LOG file !!!!!!!!!!!
>     it slow down a lots!
> 
Yes I realized that as layed down to take a 10 minute relax!

Some statistics:

Roughly 4min 20sec 459965 records added, including creation of db and
structure. But db size 1.73 GB! Of which index 16.5 Mb and data 1.72 GB,
NoLog.

RAR 7060Kb
ZIP 10879 Kb (With RAR)
7z  4537kb

All normal compression, whole db 4 files.

Joakim

> 
> --
> 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]
> 
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>