V4RB (2 questions)

Ruslan Zasukhin ruslan_zasukhin at valentina-db.com
Tue Feb 21 02:05:13 CST 2012


On 2/20/12 2:45 PM, "Christian - ChrisKatDev.com"
<christian at chriskatdev.com> wrote:

> Also when you do batch operation on table,
> It can be good idea disable indexes
> 
>     Vtable.IndexChanges = FALSE
> 
>         do job
> 
>     Vtable.IndexChanges = TRUE
> 
> just before VTAble.Flush or juste after flush ?

I think After Flush.

Flush - saves your major data - records

>     Vtable.IndexChanges = TRUE


Reindex back the whole table.



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




More information about the Valentina mailing list