Re: Performance with qualifier/scope (was RE: GETFILE() Returns Empty String in Some Cases)
A few thoughts: STORE can only refer to variables. FOR...ENDFOR loops only use variables.. The assignment x = y implies that x must be a variable (you cannot assign to a field using that syntax). The assignment x = m.y would remove any ambiguity. There are a load more examples on the FoxWiki http://fox.wikis.com/wc.dll?Wiki~EssentialMDot~Wiki. Laurie On 4 August 2017 at 22:02, Alan Bourkewrote: > More typing, never seen the point. > > -- > Alan Bourke > alanpbourke (at) fastmail (dot) fm > > On Fri, 4 Aug 2017, at 10:49 AM, > mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: > > On 2017-08-03 18:23, Darren wrote: > > > Personally I use this approach ... > > > > > > STORE m.variable|obj.property|table.fieldname to variable. Fully > > > qualify > > > everything / always. Easier to debug as well. > > > > > > Additional to results below ... STORE/ = | with/without m. | with/ > > > without > > > table open. > > > > > > No Table Open x=y 0.1320 > > > No Table Open STORE y to x0.0870 > > > No Table Open x=m.y 0.1328 > > > No Table Open STORE m.y to x 0.0879 > > > Table Open x=y 0.2081 > > > Table Open STORE y to x0.1644 > > > Table Open x=m.y 0.1326 > > > Table Open STORE m.y to x 0.0879 > > > > > > No Table Open STORE y to x0.0870 > > > No Table Open STORE m.y to x 0.0879 > > > Table Open STORE m.y to x 0.0879 > > > No Table Open x=y 0.1320 > > > Table Open x=m.y 0.1326 > > > No Table Open x=m.y 0.1328 > > > Table Open STORE y to x0.1644 > > > Table Open x=y 0.2081 > > > > > > Can't argue with the numbers, but personally I've never liked STORE. No > > good reason I guess except it never felt normal (but hey, that's > > ok...use the Fox at its best, however that is!). > > > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAMvTR9d3F9m__j-jB_cQzRah805OuasniaUms-XH-51Je8=w...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Performance with qualifier/scope (was RE: GETFILE() Returns Empty String in Some Cases)
More typing, never seen the point. -- Alan Bourke alanpbourke (at) fastmail (dot) fm On Fri, 4 Aug 2017, at 10:49 AM, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote: > On 2017-08-03 18:23, Darren wrote: > > Personally I use this approach ... > > > > STORE m.variable|obj.property|table.fieldname to variable. Fully > > qualify > > everything / always. Easier to debug as well. > > > > Additional to results below ... STORE/ = | with/without m. | with/ > > without > > table open. > > > > No Table Open x=y 0.1320 > > No Table Open STORE y to x0.0870 > > No Table Open x=m.y 0.1328 > > No Table Open STORE m.y to x 0.0879 > > Table Open x=y 0.2081 > > Table Open STORE y to x0.1644 > > Table Open x=m.y 0.1326 > > Table Open STORE m.y to x 0.0879 > > > > No Table Open STORE y to x0.0870 > > No Table Open STORE m.y to x 0.0879 > > Table Open STORE m.y to x 0.0879 > > No Table Open x=y 0.1320 > > Table Open x=m.y 0.1326 > > No Table Open x=m.y 0.1328 > > Table Open STORE y to x0.1644 > > Table Open x=y 0.2081 > > > Can't argue with the numbers, but personally I've never liked STORE. No > good reason I guess except it never felt normal (but hey, that's > ok...use the Fox at its best, however that is!). > > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/1501880557.3304411.1063593704.604bc...@webmail.messagingengine.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Performance with qualifier/scope (was RE: GETFILE() Returns Empty String in Some Cases)
On 2017-08-03 18:23, Darren wrote: Personally I use this approach ... STORE m.variable|obj.property|table.fieldname to variable. Fully qualify everything / always. Easier to debug as well. Additional to results below ... STORE/ = | with/without m. | with/ without table open. No Table Open x=y 0.1320 No Table Open STORE y to x0.0870 No Table Open x=m.y 0.1328 No Table Open STORE m.y to x 0.0879 Table Open x=y 0.2081 Table Open STORE y to x0.1644 Table Open x=m.y 0.1326 Table Open STORE m.y to x 0.0879 No Table Open STORE y to x0.0870 No Table Open STORE m.y to x 0.0879 Table Open STORE m.y to x 0.0879 No Table Open x=y 0.1320 Table Open x=m.y 0.1326 No Table Open x=m.y 0.1328 Table Open STORE y to x0.1644 Table Open x=y 0.2081 Can't argue with the numbers, but personally I've never liked STORE. No good reason I guess except it never felt normal (but hey, that's ok...use the Fox at its best, however that is!). ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/153adb6149f9e8fdaf249d24a5667...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.