Uploaded image for project: 'eZ Publish / Platform'
  1. eZ Publish / Platform
  2. EZP-20975

SearchService: optimize sql queries: do not execute count when fetching all results

    XMLWordPrintable

Details

    • Icon: Improvement Improvement
    • Resolution: Unresolved
    • Icon: High High
    • None
    • None
    • None
    • None

    Description

      When searching content with no offset, limit, you can get away with not doing 2 db queries but just one.
      For details see https://github.com/ezsystems/ezpublish-kernel/commit/c9b7ad6ab93cfeebec4a3fde641b952bb7368be1 (comments in there)

      Attachments

        Activity

          People

            Unassigned Unassigned
            gaetano.giunta-obsolete@ez.no Gaetano Giunta (Inactive)
            Votes:
            1 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: