How to Update a record and not get orphan segments?

[Trevor DeVore]

On 8/12/03 Frank Schima wrote

>
>On Monday, August 11, 2003, at 11:01  PM, Trevor DeVore wrote:
>
>> On 8/11/03 Frank Schima wrote
>>
>>> Are you calling Flush on the database immediately after the Insert?
>>
>> No I am not.  Is that required?
>
>No, but I believe that you need to call Flush eventually. It is 
>certainly good practice to keep your database healthy. The question is 
>how often to call it because it is relatively slow. For instance when 
>performing database changes in a loop, you generally want to call Flush 
>once after the loop. I would recommend you try it in your case since 
>you are seeing minor database corruption.


I think I have found where the problem is.  Originally I only had the Indexed by words Flag set on the field that was getting orphan segments.  I have now changed it so that the Indexed Flag is set as well and I am not getting orphan segments.

-- 
Trevor DeVore
Blue Mango Multimedia
trevor at mangomultimedia.com