V5RB - Phantom records in index

[Ruslan Zasukhin]

On 10/19/14, 6:30 AM, "Steve Albin" <steve at steve-albin.com> wrote:

Hi Steve,

Can you remind: 
    * version 
    * API you are using
    * Local or client-server


> For some SQL queries, I am getting repeats of the same records in the cursor.
> When I view the database using VStudio, I can see that there is only one
> record, but 5 of them will be returned in the cursor.
> 
> I don't think this is a bug in Valentina or my SQL.  But I do a diagnose on
> the database and for one field involved the query, I have a problem where
> diagnose says there are 4,848 phantom records in the index.
> 
> So, I believe I have an error in my app somewhere when I create these records.
> My problem is that I'm not seeing it.
> 
> Is there something specific I can look for that creates phantom index records?
> What is a "phantom" index record?

If I not mistaken,
This is the case when index have { value, recID },
but there is no record at recID.

So this is related to deletion of records I think.

May be there is sense to open issue in Mantis,
And step by step collect info there.


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