Table structure?

[Ruslan Zasukhin]

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

2) make sure that you DO NOT make flush() after each AddRecord().

3) Ohhhhhhh!

    and set OFF this LOG file !!!!!!!!!!!
    it slow down a lots!


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