RE: [sqr-users] Move Command

["Alexander, Steve" <Steven.Alexander@sanjoseca.gov>]

Move, add, subtract, multiply, and divide are currently faster than let,
though let will catch-up in the next version of SQR.  However, the time
spent on database operations (inserts, updates, deletes, and selects) is
usually several orders of magnitude greater than anything you might do with
variables in memory.  That's where you should focus your efforts.

-----Original Message-----
From: Bartlett, Dwain [mailto:dbartlett@state.mt.us]
Sent: Thursday, November 18, 2004 10:02 AM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Subject: RE: [sqr-users] Move Command


PeopleSoft recommends using the move command where ever possible.

Dwain Bartlett
SABHRS Services Bureau, ITSD
HR Systems Analyst
(406) 444-0418
dbartlett@state.mt.us


-----Original Message-----
From: Murty Mirthipati Venkata Suryanarayan [mailto:murtym@hexaware.com]
Sent: Thursday, November 18, 2004 10:57 AM
To: This list is for discussion about the SQR database reportinglanguage
from Hyperion Solutions.
Subject: [sqr-users] Move Command


Hi Guys,

    I am trying to optimize process time of an SQR, in which all the
assignments are done using Move command. 

    Whether Move is costiler than Let statement in terms of execution time? 

     First of all, whether this question makes any sense?

     Any ideas are most welcome. Thanks in advance.    

With Best Regards,

Murty ;)

 


DISCLAIMER:
Information contained and transmitted by this E-MAIL is proprietary to
Hexaware Technologies and is intended for use only by the individual or
entity to which it is addressed and may contain information that is
privileged, confidential or exempt from disclosure under applicable law.
If this is a forwarded message, the content of this E-MAIL may not have
been sent with the authority of the Company. If you are not the intended
recipient, an agent of the intended recipient or a person responsible
for delivering the information to the named recipient, you are notified
that any use, distribution, transmission, printing, copying or
dissemination of this information in any way or in any manner is
strictly prohibited. If you have received this communication in error,
please delete this mail & notify us immediately at
adminchn@hexaware.com.

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