PDO: Switch from EXISTS to IN in subqueries.

NatLibFi / RecordManager

A metadata record management system written in PHP, intended to be used in conjunction with VuFind or another Solr-based discovery interface. Provides import, export, harvesting (OAI-PMH), normalization, deduplication and Solr index update functionality with support for multiple metadata formats. Also includes an OAI-PMH provider that can be used to access the data stored in RecordManager database. Functionality driven by simple command line programs for easy automation.

GNU General Public License v2.0

47 stars 31 forks source link

PDO: Switch from EXISTS to IN in subqueries. #104

Closed EreMaijala closed 2 years ago

EreMaijala commented 2 years ago

This should improve performance e.g. with MySQL 5.7.

EreMaijala commented 2 years ago

@demiankatz Would this work for you?

EreMaijala commented 2 years ago

Reported to work. :)