<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><br><div><div>Le 19 févr. 2012 à 22:44, Ruslan Zasukhin a écrit :</div><br class="Apple-interchange-newline"><blockquote type="cite"><div>On 2/19/12 7:04 PM, "Christian - <a href="http://ChrisKatDev.com">ChrisKatDev.com</a>"<br><<a href="mailto:christian@chriskatdev.com">christian@chriskatdev.com</a>> wrote:<br><br>Hi Christian, <br></div></blockquote><i>Hi Ruslan,</i><br><blockquote type="cite"><div><br><blockquote type="cite">With V4RB 4.9.1, what is the fastest way to insert a large number of records<br></blockquote><blockquote type="cite">in a table ?<br></blockquote><br><blockquote type="cite">Must I choose sql insert or addRecord in the table or another way ?<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">I have change from INSERT to addRecord (VTable) but I have no really<br></blockquote><blockquote type="cite">difference of speed (??)<br></blockquote><br>Ways to add records from slow to faster:<br><br>A) INSERT e,g, 80 secs<br>B) INSERT with binding e.g. 20 secs<br>C) Vtable.AddRecord e.g 8 sec<br>D) Vtable.AddRecord and get Refs to fields before loop -- 2 sec<br></div></blockquote><br><i>I use currently this last method</i><br><div><br></div><i>Valentina support INSERT multi-records ? (several records in same request)<br></i><blockquote type="cite"><div><br><br>Also when you do batch operation on table,<br>It can be good idea disable indexes<br><br> Vtable.IndexChanges = FALSE<br><br> do job<br><br> Vtable.IndexChanges = TRUE<br></div></blockquote><div><br></div><i>just before VTAble.Flush or juste after flush ?</i></div><div><i><br></i><blockquote type="cite"><div><br><br><br><blockquote type="cite">Other : Do you work on V4RB cocoa ?<br></blockquote><br>As I know V4RB works in cocoa far ago ...<br></div></blockquote><div><br></div><i>all right :-)</i></div><div><i><br></i></div><div><i>best regards</i></div><div><i>Christian</i><br><blockquote type="cite"><div><br><br><br><br><br>-- <br>Best regards,<br><br>Ruslan Zasukhin<br>VP Engineering and New Technology<br>Paradigma Software, Inc<br><br>Valentina - Joining Worlds of Information<br><a href="http://www.paradigmasoft.com">http://www.paradigmasoft.com</a><br><br>[I feel the need: the need for speed]<br><br><br>_______________________________________________<br>Valentina mailing list<br><a href="mailto:Valentina@lists.macserve.net">Valentina@lists.macserve.net</a><br><a href="http://lists.macserve.net/mailman/listinfo/valentina">http://lists.macserve.net/mailman/listinfo/valentina</a><br></div></blockquote></div><br></body></html>