Speed of Insert into

[Tim James]

Whoops - what I meant to say in 2. is

>>  If so is there any way of deleting an index (flag) from as field and
>> then adding it back after the loop insert
>> is completed.
  USING SQL not BO.indexed=false

thanks for the answers


On 13/11/2003, at 8:08 PM, Ruslan Zasukhin wrote:

> on 11/13/03 2:50 AM, Tim James at tjames1 at bigpond.net.au wrote:
>
> Hi Tim,
>
>> It has been a while since this has been discussed so
>>
>>
>> 1."Does Insert into" in V4RB SQL automatically update indexed fields
>> after each insert.
>
> yes
>
>> 2. If so is there any way of deleting an index (flag) from as field 
>> and
>> then adding it back after the loop insert
>> is completed.
>
> Yes of course.
>
> And this is RECOMMENDED way if you going ad MANY records comparing to 
> the
> number of existed records. For example 10%.
>
>> 3. Is a curs.update loop after a importtext faster than the sql insert
>> into
>
> I do not think so. UPDATE operation require DELETE + INSERT.
> So it is slower of DELETE and INSERT itself.
>
> -- 
> Best regards,
> Ruslan Zasukhin      [ I feel the need...the need for speed ]
> -------------------------------------------------------------
> e-mail: ruslan at paradigmasoft.com
> web: http://www.paradigmasoft.com
>
> To subscribe to the Valentina mail list go to:
> http://lists.macserve.net/mailman/listinfo/valentina
> -------------------------------------------------------------
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>