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 <[email protected]> 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 < > [email protected]> 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:[email protected] > ********************************************************************** -- ************************************************* 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:[email protected] **********************************************************************
