Hi,
I would like to make a question about database access performance... (independently if it is a SQL SGBD, an Oracle SGBD or whatever).
When designing an application one can choose to control the connections between tables by hard code, or by making them inside the SGBD.
When I was using databases (so I was not coding) I learned that we should make the connections inside the SGBD (primary key to foreign-key) because this way the SGBD would create (not visible to us) something like an auxiliar table that would speed up the connection between those tables.
When I started programming I realise that most of the times, programers make those connections by code.
My question is, what are the desavantages and vantages of each option?
Anyone knows where I can find something to read about that?
Ps: For me I think we should make those relations inside the SGBD because that will speed up the access to them from code. Another reason is that we could easly realized how the tables connect with each other.
Sergio Oliveira
I would like to make a question about database access performance... (independently if it is a SQL SGBD, an Oracle SGBD or whatever).
When designing an application one can choose to control the connections between tables by hard code, or by making them inside the SGBD.
When I was using databases (so I was not coding) I learned that we should make the connections inside the SGBD (primary key to foreign-key) because this way the SGBD would create (not visible to us) something like an auxiliar table that would speed up the connection between those tables.
When I started programming I realise that most of the times, programers make those connections by code.
My question is, what are the desavantages and vantages of each option?
Anyone knows where I can find something to read about that?
Ps: For me I think we should make those relations inside the SGBD because that will speed up the access to them from code. Another reason is that we could easly realized how the tables connect with each other.
Sergio Oliveira
