E
E
Evgeny Konkin2015-10-10 02:59:30
PHP
Evgeny Konkin, 2015-10-10 02:59:30

Query against one database or two. Who cares?

Hi all!
There is one database.
For example, it has tables:

  1. users: 1000000 entries
  2. goods: 1000000 records
  3. etc.

And so. When registering, I have an Ajax request when entering each character in the login input for availability in the database-> users.
And for example, in parallel on the site, several more users are looking for something in the database-> products.
Does it make sense to separate those tables across different databases to make queries easier? Or does it make no sense?
Briefly . Will the load become easier with requests to different databases than with the same number of requests to one database?
Thank you!

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexander, 2015-10-10
@konnn

No, it doesn't. Unless, of course, each of the databases is moved to a separate server. :)

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question