RE: [sqr-users] Elapsed time in query processing

["Carlton Conley" <cconley@cdg-inc.com>]

you could always put show statements in and wrap them around the SQL commands 
to return timings.  We have played around with moving and let with large 
amouths of data just to test and have never seen enough difference in the 
typing of the two to make much difference. As someone already mentioned, 
spending time tuning the SQL will produce much greater results

-----Original Message-----
From: sqr-users-bounces+cconley=cdg-inc.com@sqrug.org
[mailto:sqr-users-bounces+cconley=cdg-inc.com@sqrug.org]On Behalf Of
Murty Mirthipati Venkata Suryanarayan
Sent: Thursday, November 18, 2004 1:30 PM
To: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.
Subject: [sqr-users] Elapsed time in query processing


Thanks a lot for the quick info on Move command and the optimizing points.
I am currently tuning the queries. But the DB2 environment is not allowing me 
to see the elapsed time for each query as it would be possible in Oracle with 
just one statement "set timer on"
I dont have access to trace file to analyze the same. I have access to just 
command center.
 
I hope this should be possible in command center too. Any idea guys..
 
Thanks for the help again.
 
With Best Regards,
Murty ;)

        -----Original Message----- 
        From: Alexander, Steve [mailto:Steven.Alexander@sanjoseca.gov] 
        Sent: Thu 18-Nov-2004 13:13 
        To: 'This list is for discussion about the SQR database 
reportinglanguagefrom Hyperion Solutions.' 
        Cc: 
        Subject: RE: [sqr-users] Move Command
        
        

        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
        
        


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.
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.797 / Virus Database: 541 - Release Date: 11/15/2004

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.797 / Virus Database: 541 - Release Date: 11/15/2004
 


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