all groups > sql server new users > december 2004 >
You're in the

sql server new users

group:

Report slows down other applications


Report slows down other applications Helen Stein
12/20/2004 1:24:47 PM
sql server new users:
Hello,

I wrote a report in COBOL using embedded SQL. This report opens 5
insensitive cursors (to avoid locking) sometimes one within the other to
access data. 5 tables accessed by this report used in the mission critical
applications that require high performance and speed for insert, update and
delete operations.

Problems:

1.. Report runs slower than I was hoping for.
2.. Running report noticeably slows down other applications that require
speed.


I would appreciate any advice, thought or suggestion.

Thank you,

Helen

RE: Report slows down other applications Pace
12/24/2004 2:35:04 AM
the reason it is slow will be down to the amount of cursors imo.

[quoted text, click to view]
AddThis Social Bookmark Button