isn't there some trick to use a character code instead of at? and does the "beginning and end" pref possibly apply?
> On Sep 12, 2017, at 8:22 AM, Jeffrey Kain via 4D_Tech <[email protected]> > wrote: > > 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] > ********************************************************************** ********************************************************************** 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] **********************************************************************
