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:4d_tech-boun...@lists.4d.com] On Behalf Of Jeffrey Kain > via > 4D_Tech > Sent: Tuesday, September 12, 2017 5:23 PM > To: 4d_tech@lists.4d.com > Cc: Jeffrey Kain <jeffrey.k...@gmail.com> > 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";=;"desig...@sweetwater.com") > > > 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:4d_tech-unsubscr...@lists.4d.com > ********************************************************************* > * ********************************************************************** 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 **********************************************************************