- ABP Framework version: v4.4.X
- UI type: MVC
- DB provider: EF Core / MongoDB
- Tiered (MVC) or Identity Server Separated (Angular): yes
- Exception message and stack trace:
- Steps to reproduce the issue:"
We would like to know/understand the sorting & filter mechanisum with in ABP.io DB repository.
Lets suppose we have 44 records in the table/collection and user has a record count as 10 by defauly. While fetching the data will it get all 44 records and then sort/filter the data to return the 10 records? or only fetch 10 records from the DB based on the sort/filter.
We have observed that the query is fetching all 44 first then sort/filter is applied. If this is the case what woud be the case if we have millions of records looded into the table/collection.
AFter filter/sorting is applided based on the record count per page
9 Answer(s)
-
0
Hi,
It should be filtering and pagination in the database, does it not work for you?
Could you share the code? thanks.
Markdown supported.Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post) -
0
can I know why this issue marked as closed without proper resolution or response
Markdown supported.Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post) -
0
Hi,
Because this qustion has not been active for a long time, system will automatically close it.
Markdown supported.Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post) -
0
Yes we had a communication 6 days before, I think 6 days is very short to close the ticket. By the way did u got a chance to check the code which I shared?
Markdown supported.Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post) -
0
Could you share the code? thanks.
Markdown supported.Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post) -
0
Could you share the code? thanks.
Yes over the email, anyway just sharing once again to shiwei.liang@volosoft.com.
Markdown supported.Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post) -
0
HI,
Got it, I will check it out.
Markdown supported.Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post) -
0
Hi,
After my check ,actually, there is no problem.
It will query the database twice:
When you click on the result of queryable, it will send additional commands to the database:
Markdown supported.Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post) -
0
Hi,
After my check ,actually, there is no problem.
It will query the database twice:
When you click on the result of queryable, it will send additional commands to the database:
Thanks for the input, we will cross check and update u back
Markdown supported.Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)
