vTable.AddRecord

[Ruslan Zasukhin]

On 4/14/10 12:40 AM, "Infinity Development Team"
<dev at infinitydatasystems.com> wrote:

> I didn't try that but I did remove the IndexbyWords in favor just a standard
> Index. That seemed to solve the problem entirely.

Hi Matt,

But now question is:
    if you really need index on TEXT field which is not BY WORDS?

Such index will use as a KEY the first 256 bytes of your text.

> It also sped up import by a
> factor of five.

Thanks for the help
Matt

Import? 

Actually if Valentina see that import is big quite comparing to table size,
Then it disable indexing, do import, then do reindex.


Note, that you also can control such disabling of index and then REINDEX,
Using 
    VTable.IndexChanges = false

        ... Massive changes

    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]