Perfomance - Happi-cat/Untech.SharePoint GitHub Wiki
Contents
- Fetch all items with all fields
- Fetch all items, but fetch only ID and Title fields
- Filter items and fetch all fields
- Take first 10 items with all fields
- Filter items and select top 10 with all fields
- Filter items and select first item with all fields
- Filter items and select last item with all fields
Test list contains 10 fields:
- Standard fields like: ID, Title, Created, Author, Modified, Editor, ContentTypeId;
- Body - multiline text field;
- Description - multiline text field;
- HeadingImage - URL Field.
All LINQ queries and equal CAML queries can be found here.
Fetch all items and all fields
-
of iterations per test (attempts): 1000
-
of items per test: 541000
-
of items per iteration: 541
| Query |
API |
Ticks |
Elapsed total |
Elapsed per iteration |
| Linq |
Client |
3564860913 |
00:05:56.4860913 |
00:00:00.3564860 |
| Caml |
Client |
3389602974 |
00:05:38.9602974 |
00:00:00.3389602 |
| Linq |
Server |
1807292742 |
00:03:00.7292742 |
00:00:00.1807292 |
| Caml |
Server |
1404672437 |
00:02:20.4672437 |
00:00:00.1404672 |
Fetch all items and select Id and Title fields only
-
of iterations per test (attempts): 1000
-
of items per test: 541000
-
of items per iteration: 541
| Query |
API |
Ticks |
Elapsed total |
Elapsed per iteration |
| Linq |
Client |
1357807651 |
00:02:15.7807651 |
00:00:00.1357807 |
| Caml |
Client |
1259005661 |
00:02:05.9005661 |
00:00:00.1259005 |
| Linq |
Server |
429471882 |
00:00:42.9471882 |
00:00:00.0429471 |
| Caml |
Server |
331044104 |
00:00:33.1044104 |
00:00:00.0331044 |
Filter items & select all fields
-
of iterations per test (attempts): 1000
-
of items per test: 205000
-
of items per iteration: 205
| Query |
API |
Ticks |
Elapsed total |
Elapsed per iteration |
| Linq |
Client |
2139067780 |
00:03:33.9067780 |
00:00:00.2139067 |
| Caml |
Client |
2057473843 |
00:03:25.7473843 |
00:00:00.2057473 |
| Linq |
Server |
1274333075 |
00:02:07.4333075 |
00:00:00.1274333 |
| Caml |
Server |
1151065316 |
00:01:55.1065316 |
00:00:00.1151065 |
Take first 10 items with all fields
-
of iterations per test (attempts): 1000
-
of items per test: 10000
-
of items per iteration: 10
| Query |
API |
Ticks |
Elapsed total |
Elapsed per iteration |
| Linq |
Client |
450679815 |
00:00:45.0679815 |
00:00:00.0450679 |
| Caml |
Client |
409987434 |
00:00:40.9987434 |
00:00:00.0409987 |
| Linq |
Server |
85922196 |
00:00:08.5922196 |
00:00:00.0085922 |
| Caml |
Server |
60769307 |
00:00:06.0769307 |
00:00:00.0060769 |
Filter & take first 10 items with all fields
-
of iterations per test (attempts): 1000
-
of items per test: 10000
-
of items per iteration: 10
| Query |
API |
Ticks |
Elapsed total |
Elapsed per iteration |
| Linq |
Client |
499498997 |
00:00:49.9498997 |
00:00:00.0499498 |
| Caml |
Client |
458163643 |
00:00:45.8163643 |
00:00:00.0458163 |
| Linq |
Server |
142686397 |
00:00:14.2686397 |
00:00:00.0142686 |
| Caml |
Server |
112474308 |
00:00:11.2474308 |
00:00:00.0112474 |
Filter & take first 1 item with all fields
-
of iterations per test (attempts): 1000
-
of items per test: 1000
-
of items per iteration: 1
| Query |
API |
Ticks |
Elapsed total |
Elapsed per iteration |
| Linq |
Client |
400359375 |
00:00:40.0359375 |
00:00:00.0400359 |
| Caml |
Client |
369920766 |
00:00:36.9920766 |
00:00:00.0369920 |
| Linq |
Server |
74225972 |
00:00:07.4225972 |
00:00:00.0074225 |
| Caml |
Server |
49886806 |
00:00:04.9886806 |
00:00:00.0049886 |
Filter & take last 1 item with all fields
-
of iterations per test (attempts): 1000
-
of items per test: 1000
-
of items per iteration: 1
| Query |
API |
Ticks |
Elapsed total |
Elapsed per iteration |
| Linq |
Client |
425502657 |
00:00:42.5502657 |
00:00:00.0425502 |
| Caml |
Client |
390647951 |
00:00:39.0647951 |
00:00:00.0390647 |
| Linq |
Server |
64901921 |
00:00:06.4901921 |
00:00:00.0064901 |
| Caml |
Server |
39065666 |
00:00:03.9065666 |
00:00:00.0039065 |