Search query performance

[ku3mich]

while executing search query there is an EF warning:
Microsoft.EntityFrameworkCore.Query:Warning: The LINQ expression 'GroupBy([p].Id, [p])' could not be translated and will be evaluated locally.

then I see multiple queries to DB one per groupping result

SELECT "p"."Key", "p"."Authors", "p"."Description", "p"."Downloads", "p"."HasReadme", "p"."IconUrl", "p"."Id", "p"."Language", "p"."LicenseUrl", "p"."Listed", "p"."MinClientVersion", "p"."ProjectUrl", "p"."Published", "p"."RepositoryType", "p"."RepositoryUrl", "p"."RequireLicenseAcceptance", "p"."RowVersion", "p"."Summary", "p"."Tags", "p"."Title", "p"."Version"
FROM "Packages" AS "p"
WHERE "p"."Id" IN (
SELECT DISTINCT "p2"."Id"
FROM "Packages" AS "p2"
ORDER BY "p2"."Id"
LIMIT @__take_1 OFFSET @__skip_0
)
ORDER BY "p"."Id"

[ku3mich]

seems related to dotnet/efcore#12255 does anyone know how to resolve it?

[ku3mich]

seems it is not a bug - it is EF Core feature ( dotnet/efcore#2341