[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] SQR V6 and SQL Server 2000
- Subject: [sqr-users] SQR V6 and SQL Server 2000
- From: John Czekaj <jrc4adp@yahoo.com>
- Date: Mon, 17 Jul 2006 12:14:14 -0700 (PDT)
- Delivery-date: Mon, 17 Jul 2006 15:16:36 -0400
- Domainkey-signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding;b=pSAyQtg1Vk8kjQY24+NtCx3POnEKhTK2jkjsddUbzMSvsSqt99LtNs6wkvhzhp5rzqF3T8ZYlUAOfdJm2X+trKPq9kKgH1L7z4Vit9ANPJI+WxTdCVtSX/BnHKqR4HZx8hWcfAuwA9tUE+sBq44yv4eQwj5/5HpFvzag/Sl/FMY=;
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
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