Unable to disable indexing

[Ed Kleban]

Interestingly, the problem noted below does not appear to occur when the
field is not declared as "fUnique" (and therefore indexed) in the field
declaration.  I.e after changing the term "fUnique" to "fNone" in the
following line, the problem noted below does not occur:

    fSpanObRef = new VLong( "FSpanObRef" , EVFlag.fUnique )

I'm not sure yet whether having enabled indexing dynamically as opposed to
at instantiation time, whether it is any more ammenable to being disabled.

Interestingly however, the speed improvement of disabling indexing is
surprisingly slight, shaving 7 seconds off of 61 seconds for building a
table of 100,533 in-RAM records.  I'm not sure whether that's bad because
the savings is so slight, or good because it means management of the indices
is so efficient -- but I think it's the later.

The fact that it takes on the order of a minute to do this however is a big
concern.  I'll spend some more time tomorrow figuring out where all the time
is being spent.  It may make more sense to just build this as a table with a
single indexed column rather than as a table having this as one column out
of five.

But the good news is I've finally got Valentina up and running, er uh, well
up and limping at least, and have some empirical results to start wading
around in.



On 11/27/05 10:01 PM, "Ed Kleban" <Ed at kleban.com> wrote:

> Should I be able to disable indexing?
> 
> Execution of the following code results in an "Indexing still enabled"
> failure.
> 
>   
>   // Disable indexing while filling the table
>   spanSrcIdField = LTblSrcSpan.fSpanObRef
>   spanSrcIdField.IsIndexed = false
>   spanSrcIdField.IsUnique = false
>   
>   #if DebugBuild then
>     if spanSrcIdField.IsUnique then
>       fail( here, "Unique still set" )
>     elseif spanSrcIdField.isIndexed then
>       fail( here, "Indexing still enabled" )
>     end
>   #endif
> 
> Running V4RB on Mac OS X 10.4.2
> 
> Thanks!
> --Ed
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina