vTable.AddRecord

[Bart Pietercil]

And what is the sql equivalent of this nice call ?

tia

Bart Pietercil
CTO Cognosis NV



On 19 Apr 2010, at 14:12, Ruslan Zasukhin wrote:

> On 19/4/10 12:33 AM, "Bart Pietercil" <bart.pietercil at cognosis.be> wrote:
> 
>> Sorry to chime in guys.
>> 
>> I seem to remember that this thread started with a question from Matt asking
>> how he could speed up importing records ?
>> If this is correct it seems to me that the standard solution for this kind of
>> problem has not yet been suggested.
>> 
>> Just before importing drop all indexes on the table you are importing to and
>> once finished importing rebuild your indexes.
>> 
>> If I missed the boat completely please disregard.
> 
> Hi Bart,
> 
> Actually I have mention this way, and let me repeat once again.
> 
>    Just drop all indexes in table, then return them back,
>    can require from you
> 
>    a) write 2 functions to do this correctly
>    b) keep this functions up to date if you modify table later.
> 
> 
> Instead of all this, we have provide simple single line way
> 
>    VTable.IndexChanges = false
> 
>        ...
> 
>    VTable.IndexChanges = true
> 
> 
> -- 
> 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