Open Closed

Sorting Mechanism while getting the data #1812


0
viswajwalith created
  • 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
    liangshiwei created
    Support Team

    Hi,

    It should be filtering and pagination in the database, does it not work for you?

    Could you share the code? thanks.

  • 0
    viswajwalith created

    can I know why this issue marked as closed without proper resolution or response

  • 0
    liangshiwei created
    Support Team

    Hi,

    Because this qustion has not been active for a long time, system will automatically close it.

  • 0
    viswajwalith created

    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?

  • 0
    liangshiwei created
    Support Team

    Could you share the code? thanks.

  • 0
    viswajwalith created

    Could you share the code? thanks.

    Yes over the email, anyway just sharing once again to [email protected]

  • 0
    liangshiwei created
    Support Team

    HI,

    Got it, I will check it out.

  • 0
    liangshiwei created
    Support Team

    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:

  • 0
    viswajwalith created

    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