Maybe there is an issue with @ character in the search string ... I've no idea how to circumvent it.
HTH Regards Lutz > -----Original Message----- > From: 4D_Tech [mailto:[email protected]] On Behalf Of Jeffrey Kain > via > 4D_Tech > Sent: Tuesday, September 12, 2017 5:23 PM > To: [email protected] > Cc: Jeffrey Kain <[email protected]> > Subject: QUERY BY ATTRIBUTE is slow af > > 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] **********************************************************************
