https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=43101

            Bug ID: 43101
           Summary: search_for_data_inconsistencies.pl creates a query
                    that ORs every biblionumber in the catalog
   Initiative type: ---
        Sponsorship ---
            status:
           Product: Koha
           Version: Main
          Hardware: All
                OS: All
            Status: NEW
          Severity: normal
          Priority: P5 - low
         Component: Architecture, internals, and plumbing
          Assignee: [email protected]
          Reporter: [email protected]
        QA Contact: [email protected]
  Target Milestone: ---

Queries that use OR instead of IN are less efficient and can lead to situations
where the query takes a very long time to complete due to row level scanning.
We found one instance where they query had been running for over 10 days!

-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
_______________________________________________
Koha-bugs mailing list -- [email protected]
To unsubscribe send an email to [email protected]
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to