Speeding up UpdateRecord

[Ruslan Zasukhin]

On 1/11/14, 7:17 PM, "Beatrix Willius" <bwillius at gmx.de> wrote:

Hi Beatrix,

> I forgot to add that Valentina Studio tells me that this field has 11MB. The
> message table has 1000 records.

This field is indexed by words, yes?

* I think main time eats indexing of each your update.


* When you make big changes over table, it is good idea to disable index
operations.

In the past we did this via

     field.Indexed = false
          big  job 
     field.Indexed = true
    

* But about 3-4 years ago, we have added feature

      Table.IndexChanges = false
          big  job 
      Table.IndexChanges = true

This allows to disable index operations on all fields of table.




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