Re: MySQL Cluster Slow Queries

[Mikael Ronström]

Hi,
A query like:
SELECT COUNT(1) FROM posts WHERE forum_id = 2
will actually be executed as a full table scan where forum_id = 2 is most
likely pushed down a condition pushdown. I am not sure how much data per
record found is sent, also you don't specify the result of the query, the
result is the number of records sent up. So obviously sending much data over
the network is much slower than internally in a box.

However it is hard to give more feedback without knowing more about the
specifics of your test case. Obviously a 100x difference sounds like
much too much.

Rgrds Mikael Ronström