Am 12.09.2017 um 17:22 schrieb Jeffrey Kain via 4D_Tech <[email protected]>: > > 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]")
If Memory serves me right: the demos at the summit only queried on first level object fields: QUERY BY ATTRIBUTE ([table]; [table]object;“name“;=;“fred“) You, sir, are trying to get to a second level value from an array Having worked with 4D since ages long forgotten, I would have to feel very lucky and outright daring to even assume such a thing might work :-) Not helpful I know…. Try searching for a first level direct value if you have such a thing. Cheers Alex ********************************************************************** 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] **********************************************************************
