RE: [sqr-users] SQR V6 and SQL Server 2000

["Jeffrey Newton" <jeffrey_d_newton@msn.com>]

I encounterd a similar problem once - the problem turned out to be that the 
ODBC driver on the  server where I ran the SQR was not up to date.  When it 
ran, the initial updates  went fairly quickly, but the longer it ran the 
longer it took to complete an update.


>From: John Czekaj <jrc4adp@yahoo.com>
>Reply-To: "This list is for discussion about the SQR database 
>reportinglanguage from Hyperion Solutions." <sqr-users@sqrug.org>
>To: sqr-users@sqrug.org
>Subject: [sqr-users] SQR V6 and SQL Server 2000
>Date: Mon, 17 Jul 2006 12:14:14 -0700 (PDT)
>
>I have an SQR that changes the value of EMPLID in all
>tables where EMLPLID is a column from SSN to a
>sequentially assigned number.  This program runs fine
>on Oracle, but on SQL Server 2000, it is a dog.  It is
>doing a commit (commit transaction/begin transaction)
>after each employee is processed, but yet it takes
>longer and longer to process employees as the SQR
>runs.  Does anyone have any suggestions as to how I
>can improve the performance of this program?  Any
>assistance would be greatly appreciated.
>
>Thanks,
>
>John Czekaj, Consultant
>ADP Professional Services - National Accounts
>
>John Czekaj
>   Consultant
>   ADP National Accounts - Professional Services
>
>
>__________________________________________________
>Do You Yahoo!?
>Tired of spam?  Yahoo! Mail has the best spam protection around
>http://mail.yahoo.com
>
>_______________________________________________
>sqr-users mailing list
>sqr-users@sqrug.org
>http://www.sqrug.org/mailman/listinfo/sqr-users



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