Slow issue with filepro on Windows 2003 / XP clients - JustStarted

[John Esak]

No, it's not a "balance" problem. It's a duplicate key problem. @rn changes
on every record of course so it couldn't be more non-duplicate than that.
One million records built on field 3 which is always empty except for two or
three recordss is going to have nearly a million duplicate keys for the
index.  With the @rn attached, every one of the million keys for that index
is different. 

John 

> -----Original Message-----
> From: filepro-list-bounces+john=valar.com at lists.celestial.com 
> [mailto:filepro-list-bounces+john=valar.com at lists.celestial.co
m] On Behalf Of Walter Vaughan
> Sent: Wednesday, January 06, 2010 8:11 AM
> To: filePro
> Subject: Re: Slow issue with filepro on Windows 2003 / XP 
> clients - JustStarted
> 
> John Esak wrote:
> 
> > I add a second key that will be unique itself, like @rn. 
> >
> >  
> >
> Wouldn't that kind of still cause balance problems in the index?
> Would @TM be something more random?
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>