MYSQL big query
#10

Quote:
Originally Posted by Extremo
Посмотреть сообщение
This is usually why things like database normalisation have been applied and used in computer science.

Here are a few interesting reads on that subject in case you are interested. They should also answer your questions.

Introduction to Normalization

These are the rules applied to the database usually:

Rules of Normalization

Stackoverflow, simply because without it this would be an incomplete answer:

StackOverflow Topic

Another tutorial that might suit your needs:

Database normalization in four quick and easy steps


What this should do is split up your queries and probably even make sure you don't have to save some data that rarely changes because it's part of a different system etcetera. This should give you a general idea on how to optimize your queries and databases, but I am sure you can also find other elegant solutions.
That's how you normalise. I still don't get how you lose connection when you use localhost. It should avoid the whole TCP/UDP connection and use a direct socket. Maybe someone else has a clue?
Reply


Messages In This Thread
[Solved] MYSQL big query [Solved] - by qmnty - 21.02.2015, 09:45
Re: MYSQL big query - by Sithis - 21.02.2015, 09:51
Re: MYSQL big query - by qmnty - 21.02.2015, 10:03
Re: MYSQL big query - by Extremo - 21.02.2015, 10:08
Re: MYSQL big query - by qmnty - 21.02.2015, 10:21
Re: MYSQL big query - by Extremo - 21.02.2015, 11:50
Re: MYSQL big query - by qmnty - 21.02.2015, 21:25
Re: MYSQL big query - by qmnty - 22.02.2015, 00:57
Re: MYSQL big query - by qmnty - 22.02.2015, 02:09
Re: MYSQL big query - by Extremo - 22.02.2015, 09:44

Forum Jump:


Users browsing this thread: 1 Guest(s)