I hope to optimize the performance of loading list data, currently only 30 pieces of data are so slow

[linkwarden]

I hope to optimize the performance of loading list data, currently only 30 pieces of data are so slow

[Nicolasking007]

After the list data exceeds 20, the page loaded data keeps repeating

[daniel31x13]

Hello @Nicolasking007, could you please elaborate on what exactly is the issue?
Also can you send me the translated version of the first image?
Thanks!

[Nicolasking007]

Hello @Nicolasking007, could you please elaborate on what exactly is the issue? Also can you send me the translated version of the first image? Thanks!

When the page data exceeds 20, pull up to refresh. Interface{baseURL}/API/routes/links? body=The body parameter in body={"sort": 0, "collectionId": 2} is duplicated by URL encoding

For example, the parameters for the first request are {"sort": 0, "collectionId": 2}, and the parameters for the second request are%257B%2522sort%2522%253A0%252C%2522collectionId%2522%253A2%257D

[Nicolasking007]

Sorry, the description of URL encoding above may be misleading

For example, the first request parameter {"sort": 0, "collectionId": 2} has an OK status and returns 20 pieces of data. The second request parameter {"cursor": 44, "sort": 0, "collectionId": 2} has an OK status and returns 2 pieces of data. The third request parameter {"cursor": 41, "sort": 0, "collectionId": 2} has an empty data return

[Nicolasking007]

by checking the relevant code of getCollections.ts andgetLinks.ts, ChatGPT told me that it seems to be caused by N+1 query issues

[daniel31x13]

This it irrelevant as of now.
It already runs pretty smoothly on multiple instances I deployed.