Table structure?

[Ruslan Zasukhin]

On 4/29/06 10:32 PM, "Ruslan Zasukhin" <sunshine at public.kherson.ua> wrote:

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

Actually you can set it in mode DebugLEvel = LogErrors
 
So log file will write ONLY errors if any.


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