Improve API Performance With Pagination #shorts

preview_player
Показать описание

Рекомендации по теме
Комментарии
Автор

Instead of List<T>, it should be IEnumerable or Read Only

cdownload
Автор

But try to avoid offset paging and instead use cursor-based paging. Offset paging can be super slow for big tables.

Rookiande
Автор

How good is C# a language for APIs? Constraints are a python/golang/non-MS dev culture and non-MS/AWS stack. Is there something comparable to C# advantages?

RaviKaranSharma
Автор

Do we have similar to this, a Filter & Sort list?

jose-sebastian-garcia
Автор

I'm using Odata for all the paging, selection, filtering stuff

tinytan
Автор

Very good info, In my case I use Sieve package in which includes some very good features if you have the chance give it a look

luisalvarenga
Автор

It could negatively impact the performance since on every page, the API will hit the database with a heavy query.

am-p
Автор

I would only page data when the requests specifies so and not by default

Hugos
Автор

Do you have a video or project about caching + pagination + single item update in the cached list? 🫣

tediashvili