Re: [sqr-users] RE: let vs move discussion part deux

[Al H <star111lists@mindspring.com>]

The difference between MOVE and LET mattered when we were programming
on 80386 machines. In today's world, the time you spent typing the
command probably took more clock time than the difference it will ever
make between the two in your program.

The best efforts of optimization are spent on making sure you are
using indices efficiently (explain plan is your friend ;)) and keeping
network traffic to a minimum by doing as much as you can using SQL
commands rather than SQR commands (caveat: As with all rules, there
are exceptions). 

BTW I don't think you're weird Denise :), your posts prove otherwise!

On Wed, 30 Jul 2003 09:33:35 -0400, you wrote:

>I was taught what Don said - that 'move' is more efficient than 'let'.  To be 
>more specific, I was taught that 'move' is three times faster than 'let'.  I 
>wasn't told anything about numeric vs. character values.  This is interesting 
>- I am always interested in programming as efficiently as possible (even 
>though some people think I'm weird because computer processors are so fast 
>that the differences are minuscule).  I routinely use 'move' wherever possible 
>(unless I have a group of statements together, have to use 'let' in some of 
>them, and want them to line up and look pretty!)
>
>Denise M. White
>Sr. Software Engineer
>Vicor 
>--__--__--
>
>Message: 17
>From: "the dragon" <ceprn@hotmail.com>
>To: sqr-users@sqrug.org
>Date: Tue, 29 Jul 2003 16:56:06 -0500
>Subject: [sqr-users] let vs move discussion part deaux
>Reply-To: sqr-users@sqrug.org
>
>Don,
>
>I cordially disagree.  Unless brio has changed anything lately, numeric 
>assignments are faster with move but character assignments are faster with 
>let because there is more overhead associated with the move command.  Maybe 
>someone from brio/sqribe in Ohio can give the definitive answer on this.
>
>As for searching the sqrug database, there isn't really that much and 
>everything I see in the database is 4 years old.
>
>in this message http://www.sqrug.org/sqr-users/sqrusers_97/msg00690.html the 
>values are all numeric.
>ditto http://www.sqrug.org/sqr-users/sqrusers_97/msg00696.html
>
>clark 'the dragon' willis
>
>
>PSA: Salary <> Slavery.  If you earn a salary, your employer is renting your 
>services for 40 hours a week, not purchasing your soul.  Your time is the 
>only real finite asset that you have, and once used it can never be 
>recovered, so don't waste it by giving it away.
>
>"Time is the coin of your life. It is the only coin you have, and only you 
>can determine how it will be spent.  Be careful lest you let other people 
>spend it for you."
>
>Carl Sandburg
>(1878 - 1967)
>
>
>----Original Message Follows----
>
>On Tue, 29 Jul 2003, the dragon wrote:
>
> > Dan,
> >
><snip>
> > also, get in the habit of using let commands rather than move commands -
> > they are more powerful in the long run and faster except for numeric 
>values.
>
>Actually, just to be nit-picky, "move" is more efficient than "let" for
>all simple assignments.  Just like "add" is more efficient than let,
>"subtract" is more ...etc.
>
>For complex assignments that would take multiple "single-purpose"
>commands, then "let" is more efficient.
>
>See archives for many discussions thereof.
>


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users