[TIPs] How to speed up Valentina

[Ruslan Zasukhin]

On 19/4/07 4:33 PM, "Tony" <tony at credit-scoring.co.uk> wrote:

Hi Tony,

> Hi Ruslan
> 
> You are right once it cahces it is VERY fast.
> I increased the cache to 25MG and indexed all the fields.
> 
> However:
> [1] The data load took over an hour ( 90 fields, 150k records)

You mean IMPORT of records, right?
Although our own import in this case will be fast.

I think you self parse data, and do INSERT. Right?

Okay, then you need use this trick:
    set Vtable.IndexChanges = false
        loop
    set Vtable.IndexChanges = true
    
This trick prevent adding into indexes during inserts.
Then rebuild all indexes -- what is much faster.

> [2] The first run took 14 minutes
> Subsquent runs took 7 seconds.

As run you mean what?
    set of GROUP BY queries?
 
> I just thought I'd let you know!
> 
> Thanks for all the help that you have provided me!

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