‫All right, so that's the client side, let's do the server side, literally copy paste, and the only
‫difference to the server side, you just give it a name, right?
‫Once you give it a name, it becomes a server side cursor, but it behaves exactly the same.
‫OK.
‫OK, what did we get?
‫Look at the results, guys with the server side cursor executing the query took three milliseconds and
‫now fetching the 50 arrows actually slightly slower than the client side because we still have to make
‫the round trip to give me the 50 rolls.
‫But it's just very it's a very cheap call because I'm getting give me only 50 rolls.
‫Right.
‫Give me the 50.
‫Give me a 50.
‫And if we do a loop, we can we can see that this is actually we can we can see that how how how long
‫it's going to take.
‫Every 50 rose is going to take two milliseconds.
‫Right.
‫So there you have it.
‫OK, you have Clydeside right.
‫If you execute, you pull everything back to the client.
‫Right.
‫And then if the server side, you leave everything on the server, but you will have to do some round
‫trip going back and forth to fetch the results.
‫OK.