[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

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


Do you have some data structure that is increasing in size as the
program runs?

Richard Knapp
AITS - Reporting
University of Missouri
Locust Street Building
Columbia, MO 65201
573-882-8856
knappr@umsystem.edu


-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of
John Czekaj
Sent: Monday, July 17, 2006 2:14 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] SQR V6 and SQL Server 2000

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