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) - query takes 66 seconds b) Find in field *Find in field*($FieldPtr->;[TableTemplates]RecordNumber) - takes 70 seconds (no match is found) It makes very little difference what type of index is selected for the field. 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? Pat -- ************************************************* 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 **********************************************************************
