]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
Optimize MySQL foreign key reflection
authorFederico Caselli <cfederico87@gmail.com>
Sat, 12 Oct 2024 12:58:26 +0000 (14:58 +0200)
committerFederico Caselli <cfederico87@gmail.com>
Sat, 12 Oct 2024 12:58:35 +0000 (14:58 +0200)
commit0dda26af500941b9ec916e1be5b6091f7072578f
tree5a477369e54cb7ecab66c5d7b067d7281dae137a
parenta9c27530952e57e73717f6f236f62ad91b4ed3a4
Optimize MySQL foreign key reflection

Improved foreign keys reflection logic in MySQL 8+ to use a better
optimized query. The previous query could be quite slow in databases
with a large number of columns.

Fixes: #11975
Change-Id: Ie8bcd810d4b37abf7fd5e497596e0ade52c3f82e
(cherry picked from commit a98d31621d58d45e2a4d74351282cedddcfe85fa)
doc/build/changelog/unreleased_20/11975.rst [new file with mode: 0644]
lib/sqlalchemy/dialects/mysql/base.py
test/dialect/mysql/test_reflection.py