I deleted the index file and recreated it, and now it works as expected :)
PB
On Thu, 15 Aug 2019 at 21:09, John DeSoi via 4D_Tech <4d_tech@lists.4d.com>
wrote:
> Seems way off. Are the values unique or clustered around a few values?
>
> I'm seeing a few milliseconds to search 46 million records with a unique
> index value.
>
> Have you tried DESCRIBE QUERY EXECUTION?
>
> John DeSoi, Ph.D.
>
> > On Aug 15, 2019, at 2:26 PM, Pat Bensky via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> >
> > There are a lot of records in the table (about 1.3 million).
> >
> > Does this seem right? 70 seconds is a long time :) And why does it say
> it's
> > doing a *sequential* search?
>
> **
> 4D Internet Users Group (4D iNUG)
> Archive: http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub: mailto:4d_tech-unsubscr...@lists.4d.com
> **
--
*
CatBase - Top Dog in Data Publishing
tel: +44 (0) 207 118 7889
w: http://www.catbase.com
skype: pat.bensky
*
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:4d_tech-unsubscr...@lists.4d.com
**