V4RB (2 questions)

[Christian - ChrisKatDev.com]

Le 19 févr. 2012 à 22:44, Ruslan Zasukhin a écrit :

> On 2/19/12 7:04 PM, "Christian - ChrisKatDev.com"
> <christian at chriskatdev.com> wrote:
> 
> Hi Christian, 
Hi Ruslan,
> 
>> With V4RB 4.9.1, what is the fastest way to insert a large number of records
>> in a table ?
> 
>> Must I choose sql insert or addRecord in the table or another way ?
>> 
>> I have change from INSERT to addRecord (VTable) but I have no really
>> difference of speed (??)
> 
> Ways to add records from slow to faster:
> 
> A) INSERT                                e,g, 80 secs
> B) INSERT with binding            e.g. 20 secs
> C) Vtable.AddRecord               e.g 8 sec
> D) Vtable.AddRecord  and get Refs to fields before loop -- 2 sec

I use currently this last method

Valentina support INSERT multi-records ? (several records in same request)
> 
> 
> 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 ?

> 
> 
> 
>> Other : Do you work on V4RB cocoa ?
> 
> As I know V4RB works in cocoa far ago ...

all right :-)

best regards
Christian
> 
> 
> 
> 
> 
> -- 
> 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20120220/83dc15c2/attachment.html>