Hello,
I have a database with about 25 tables and almost every table having a foreign key on some other table. They system needs to deal with a large number of reads and writes. I'm concerned if having too many foreign keys and relationships between tables will lock the tables on inserts and updates and this might reduce the concurrency on table access. What should I look out for?

if we consider the purpose to use foreign key is to link one key to another table so we can keep look up the detail information in separate table
but it has consequences: if will speed up searching but it will slow down the update.
if the parent table has only few records and only one field e.g. sex it will be male or female; i think it is better to put the value directly instead of using separate table.
Also if the additional record is unlikely to be added don't use it

it is my opinion

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.