Trying to figure out why our experience with QUERY BY ATTRIBUTE is so different than the demos at the last 4D Summit.
We're running 4D Server 16.2 64-bit on Windows. The Invoices table has about 9 million rows, and we added an index to the Extra field in this table which is an object field. The following query always runs sequentially - i.e. very very slowly. Thinking it might be a wildcard issue with the email we also tried strings with no '@', but no matter what we do the query runs sequentially. QUERY BY ATTRIBUTE \ ([Invoices];\ [Invoices]Extra;\ "gift_card_line_items[].to_email";=;"[email protected]") What are we doing wrong here? The query returns one row, 20 minutes later. ********************************************************************** 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:[email protected] **********************************************************************
