Speed of Insert into

[Ruslan Zasukhin]

on 11/14/03 3:38 AM, Tim James at tjames1 at bigpond.net.au wrote:

> 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

You mean DROP flag INDEXED via SQL?

No, Tim, Valentina 1.x cannot do this.

In Valentina 2.0 we have improve ALTER TABLE a lots.
So it will be able do that.

But be warned: SQL compared to field.indexed = false
                will be about 100 times slower!

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