Table has about 150k records query with array is performed on table a number of records are in selection, but always <100. record data is in cache. Client/Server
It is necessary to step through the selection to insure that only one record exists for each array element in the query with array, and if true, do some processing. Which is faster/better? is there a difference? Query([table][table]index_Field=value) or use set Query selection([table];[table]Indexed_field=value) thanks! ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************