database - How much slow are the cursors in Sybase -

database - How much slow are the cursors in Sybase -

i have heard cursors slow in sybase, said should avoid cursors. can tell how slow cursors in sybase. read cursors fine, or slow, , acceptable utilize cursors altogether

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc20020_1251/html/databases/databases537.htm

here reply example.... sample execution times against 5000-row table

procedure | access method | time --------------------------------------------------------------------- increase_price | uses 3 table scans | 28 seconds increase_price_cursor | uses cursor, single table scan |125 seconds

database stored-procedures cursor sybase