Thomas, Yes, it was the SQL Joins which made the difference. Things ran fine in v11, v12 and v13 but the new query editor in v14/v15 really requires this option in order to run correctly.
Thanks, Paul > Le 09 Dec 2016 à 12:35, Thomas Maul <thomas.m...@4d.com> a écrit : > >> Query([Invoices];[Clients]City=“Los Angeles”) in the query editor >> will be run sequentially, even if there’s an automatic relation between the >> two tables and even >> if City is indexed. If you have hundreds of thousands, or millions of >> records, this is a killer. > > Your structure is from v2004 or older? > In our v11 update trainings we said "first thing to do, is to open > compatibility and check the first 3 check boxes". > I assume you still have them disabled? You lost a lot of power in the last > years... > The new Query editor is internally using QUERY BY FORMULA. Everything is done > with formula. > If that is slow for you, my guess is that you have disabled the high > performance features introduced with v11... > > > 4D Deutschland GmbH > Geschäftsführer Laurent Ribardière Telefon: +49-89-856 33 43-0 > Amtsgericht München HRB 92258 Fax: +49-89-856 33 43-99 > Obere Hauptstrasse 2 E-Mail: thomas.m...@4d.com > 85386 Eching - Deutschland Web: www.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 > ********************************************************************** ********************************************************************** 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 **********************************************************************