Re: Sequential search of indexed field

2019-08-16 Thread Pat Bensky via 4D_Tech
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

Re: Sequential search of indexed field

2019-08-15 Thread John DeSoi via 4D_Tech
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>

Sequential search of indexed field

2019-08-15 Thread Pat Bensky via 4D_Tech
Using v17. I need to find out if a certain entry exists in a large table. The search is conducted on an indexed field (longint). I've tested with two methods: a) Query *SET QUERY DESTINATION*(Into variable;$iCount) *QUERY*(*Table*($iTableNumber)->;$FieldPtr->=[TableTemplates]RecordNumber) - que