BD query without overloading the server

Question

BD query without overloading the server

Navigation

#1 by (2 votes)

4

Hello everyone, good night!

I need to perform several queries of an ID in an X table, but this is overloading my server and the connection with BD is off, I contacted my server and they informed me that they are trying multiple requests and so it goes offline .

So I would like to know if it is possible for me to create a new column and store all the information and forget the relationship between tables.

As I think I did not express my doubt very well, I'll leave a flow chart below:

I have seen data inserted in this way I can not remember what it is, if someone can help me with the function name or an example, thank you very much.

@UPDATE I think I found what I wanted, I think it's json_encode, I'll see how it works, if not, please let me know.

php

asked by anonymous 18.08.2016 / 02:39

1 answer

Images are repeating in ImageViews What is the difference between the operators "+" and "&" when in string concatenation?

score 2 · Accepted Answer

Yes it is possible.

What you're trying to do is DESORMALIZE a database for performance gain.

Remembering that there is no "cake recipe" about standardization. It will depend a lot on each situation.

There are several articles on this on the internet, for example: STANDARDIZATION vs DESNORMALIZATION

Also remember to create indexes in the database for fields that are used in filters ( where ) or sorting ( order by ), as this will help in performance as well.