perf: enhance global search

Pull Request Test Coverage Report for Build 11739769168

118 of 638 (18.5%) changed or added relevant lines in 10 files are covered.
4 unchanged lines in 2 files lost coverage.
Overall coverage decreased (-0.9%) to 83.562%

Changes Missing Coverage	Covered Lines	Changed/Added Lines	%
apps/nestjs-backend/src/features/record/record.service.ts	16	17	94.12%
apps/nestjs-backend/src/features/aggregation/open-api/aggregation-open-api.service.ts	6	10	60.0%
apps/nestjs-backend/src/db-provider/postgres.provider.ts	3	16	18.75%
apps/nestjs-backend/src/db-provider/sqlite.provider.ts	3	16	18.75%
apps/nestjs-backend/src/features/aggregation/open-api/aggregation-open-api.controller.ts	15	29	51.72%
apps/nestjs-backend/src/db-provider/search-query/search-query.sqlite.ts	16	106	15.09%
apps/nestjs-backend/src/db-provider/search-query/search-query.postgres.ts	16	113	14.16%
apps/nestjs-backend/src/db-provider/search-query/abstract.ts	19	120	15.83%
apps/nestjs-backend/src/features/aggregation/aggregation.service.ts	16	203	7.88%
<!--	Total:	118	638	18.5%	-->

Files with Coverage Reduction	New Missed Lines	%
apps/nestjs-backend/src/db-provider/search-query/abstract.ts	2	52.47%
apps/nestjs-backend/src/features/calculation/reference.service.ts	2	91.53%
<!--	Total:	4	-->