A small database (one machine n1) and a very large database(on machine n2, with billion records) need to be joined. The app server would need to read the data from the db servers into memory. Should it read the small db first ? and then read from the second db ?
How can this join be executed fastest ? How is this done in real life in general ?
from Recent Questions - Stack Overflow http://ift.tt/29Q2I5f
via https://ifttt.com/ IFTTT
No comments:
Post a Comment