On Mar 17, 6:22*pm, Jerry Stuckle <jstuck...@attglobal.net> wrote:
>
> I doubt that will make a search faster. *The overhead of splitting the
> request then joining the output would probably be much higher than
> letting MySQL do it itself. *Additionally, multiple nodes should not be
> accessing the same physical table.
>
The overhead involved is not a problem as i am using a MPI program to
take care of that.And since the queries run on each nodes is the
same ,but on different records,there shouldn't be a problem of
splitting and joining them together.
But i would like to know more about what u said about why multiple
nodes cant access the same table..is it really a constraint set by the
DBMS?