Speed of Insert into

[Ruslan Zasukhin]

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