What is the best database to store a list of information [closed]

Navigation
-1

I'm thinking about developing a project, in this case a website. I will need to have a database connection, I will opt for mysql . On the site people can create an account, and subsequently create a list of information about them.

List example: 

tenho isto
fiz aquilo
estudei alem
nasci aqui
...

Database example: 

Tabela User
uid
uemail
upass
unome
....

Table Information 

iid
iuid
iinfor
....

My question is the following is the best way to store the list of information I thought of in a table, but I think that in the future it can go wrong. When the Information table starts to have a lot of data I can lose a lot of time in the queries. Is there any other way I can do what I want to do without having this time lost or will it not be reflected? Or is this shape that I think will always be the best?

I still leave another question and I will take the example of facebook how is stored all the information of the users, I think they should also have everything stored in a database, but only on a machine with an abnormal amount of processing, right?

    
asked by anonymous 10.11.2016 / 14:13

1 answer

1

The question is: What database will I use, how structured is my database, and how will the application work?

One of the key factors that impact the performance of a SQL statement is the use of indexes, especially in statements that use tables with many data. This is so important that mere indexing can drastically reduce the number of internal steps in executing SQL statements. - source: #

It turns out that this method that you mentioned, is widely used, I particularly use it and never gave a scold, look what there were thousands of contents.

Database

The database you are going to use will be one of the biggest influences on search agility, as well as choose the type of each column.

For example. The application can be stable with a few hundred data using MySQL. PostgreSQL may be better, but in that case it may not be necessary to use it.

Another example is: Will the list have any maximum number of characters? You should figure out which type you should use: Text, TinyText, MediumText, LongText and etc.

Application

Another factor that can prevent a good functioning is how your application is;

For example: imagine that you need to use only the name of who pulled the list, logically would use something like SELECT nome FROM tbl_lista; , if you use SELECT * FROM tbl_lista; the application will lose performance,

See this image and reflect.

There is no secret.

So in summary, the way you want to do it has no fuss, it will depend on how you apply.

    
10.11.2016 / 14:28
SQL group records by time Returning data followed by messages