topic Re: Performance Improvement in Application Development and Automation Discussions

Performance Improvement

Former Member — Tue, 05 Feb 2008 12:40:40 GMT

If you use cursor will it improve the performance of a program?

if you use cursors in DB2 database and if you go for other data base(replatform to oracle) for example oracle will we have any problem with cursors? is cursors belong to open sql or native sql?

Re: Performance Improvement

Former Member — Tue, 05 Feb 2008 14:09:21 GMT

I've never known it to improve performance. It's used to allow several independent access paths to the same table.

It's an open SQL commnad.

You can see more by pressing F1 on OPEN.

Rob

Re: Performance Improvement

Former Member — Tue, 05 Feb 2008 16:04:32 GMT

Open cursor processing is necessary for blockwise processing of very large amounts of data, (blocks of about 10.000 records, at least several blocks) Then it helps, becomes otherwise it is hard to find to next block.

For standard SQL problems it is not necessary.

Siegfried

Re: Performance Improvement

Former Member — Tue, 05 Feb 2008 17:39:11 GMT

I think the PACKAGE SIZE option of the SELECT statement is a better option for large amounts of data. So a cursor is not needed in that case.

Rob