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
M
matros972017-04-20 10:07:09
The text does not fit into the block? 4Reply
F
Flanker3812015-05-28 16:54:35
Debian netstat output. What do the lines mean? 6Reply
N
NyxDeveloper2021-05-04 16:15:55
How to forbid assigning id to fields of ForignKey of that object, whose certain field is equal to False? 4Reply
W
WWK_12021-05-06 22:06:05
Is it possible and how to set up Prettier? 1Reply
A
Alexander Reshetnyak2017-06-17 19:35:05
Which Blender plugin is better for creating sprites for games? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question