1
00:00:00,060 --> 00:00:07,200
‫All right, so that's the client side, let's do the server side, literally copy paste, and the only

2
00:00:07,200 --> 00:00:10,580
‫difference to the server side, you just give it a name, right?

3
00:00:10,770 --> 00:00:16,410
‫Once you give it a name, it becomes a server side cursor, but it behaves exactly the same.

4
00:00:16,570 --> 00:00:16,870
‫OK.

5
00:00:19,000 --> 00:00:20,570
‫OK, what did we get?

6
00:00:21,010 --> 00:00:30,100
‫Look at the results, guys with the server side cursor executing the query took three milliseconds and

7
00:00:30,550 --> 00:00:41,650
‫now fetching the 50 arrows actually slightly slower than the client side because we still have to make

8
00:00:41,650 --> 00:00:44,080
‫the round trip to give me the 50 rolls.

9
00:00:44,080 --> 00:00:49,930
‫But it's just very it's a very cheap call because I'm getting give me only 50 rolls.

10
00:00:49,930 --> 00:00:50,160
‫Right.

11
00:00:50,230 --> 00:00:50,950
‫Give me the 50.

12
00:00:50,950 --> 00:00:51,600
‫Give me a 50.

13
00:00:51,760 --> 00:01:01,780
‫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

14
00:01:01,780 --> 00:01:02,440
‫it's going to take.

15
00:01:02,860 --> 00:01:05,080
‫Every 50 rose is going to take two milliseconds.

16
00:01:05,080 --> 00:01:05,330
‫Right.

17
00:01:05,680 --> 00:01:08,120
‫So there you have it.

18
00:01:08,140 --> 00:01:10,990
‫OK, you have Clydeside right.

19
00:01:11,180 --> 00:01:14,290
‫If you execute, you pull everything back to the client.

20
00:01:14,590 --> 00:01:14,920
‫Right.

21
00:01:15,250 --> 00:01:21,280
‫And then if the server side, you leave everything on the server, but you will have to do some round

22
00:01:21,280 --> 00:01:24,150
‫trip going back and forth to fetch the results.

23
00:01:24,200 --> 00:01:24,480
‫OK.