Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
A
A
Aidar Khayatov2018-12-01 09:49:45
MySQL
Aidar Khayatov, 2018-12-01 09:49:45

How do foreign keys reduce performance?

Can you please tell me when foreign keys reduce performance due to additional checks? Only about trying to change the data? Or about trying to get data too?
Also wondering if foreign keys are used when doing master-slave replication (given that all tables for which foreign keys are created are copied) - and is this operation expensive for performance?

Reply
Answer the question

Answer the question

In order to leave comments, you need to log in

0 answer(s)
Similar questions
F
fara_ib2019-09-21 18:21:15
How to set up adding a port to vlan after checking for 802.1x? 2Reply
N
nerik2015-07-10 12:55:01
How to organize nat before ipsec tunnel? 3Reply
H
hbrmdc2015-07-11 07:09:45
How to speed up the transfer of the main js file of webApp? 3Reply
#
#FFFFFF2019-11-19 14:39:34
What is better to use for e2e testing Vue? 3Reply
D
dimasan572019-11-24 18:57:20
How to hide a block on the main page using JS? 3Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question