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
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>
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
3 matches
Mail list logo