Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Sybase vs Oracle - which is better?
Sybase and oracle are both relational databases. Relational theory is concerned with set processing, which is far more efficient than row by row processing. What you described is using a cursor in browse mode, which is not such a major problem and may be quite valid in the case you described. Updating using cursors however is extremely inneficient. I have rewritten cursors for clients using stored procedures & temp tables and they always run faster.
In article <ncs42.2661$Sz4.1462261_at_news.teleport.com>,
"Barbara Kennedy" <barbken_at_teleport.com> wrote:
> I am not sure why you believe that cursors are "bad". Not sure what is
> "bad" about them. If I have a GUI that needs to display a long list but the
> user may not navigate the entire list why would I want to bring over the
> entire list - generates a lot of network traffic, takes a lot of room up on
> the client - RAM, generates a lot of disk i/o on the server. With a cursor
> I can get the first 20 or 30 and if the user wants to see more I can
> retrieve the next 20 or 30. There are situations where bringing entire
> results sets over in one fell swoop would be suboptimal and inefficient; not
> all cases of course.
> Jim
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Nov 19 1998 - 00:00:00 CST