for a fair comparison, I think the "query path" feature should be activated on both sides (ORDA and QUERY). you will get the time required to complete the query.
surrounding a block of code with "Milliseconds" (if that is how you got the measurements) does not feel right in this context. > Doing the query with ORDA takes 175 milliseconds. > Doing the query with QUERY takes 4 milliseconds. > > Why?? > > ORDA: > $oQRYoption:=New object("queryPlan";False;"queryPath";False) ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************