more complex queries on clusters

[Jörg Nowak]

Hello,

I have the following query:

select IMSI.mIMSI, BasicServiceCode.BasicServiceCodeId from IMSI, MSISDN, BasicServiceCode where IMSI.mIMSI=MSISDN.associatedIMSI and MSISDN.associatedBasicServices=BasicServiceCode.basicServiceCodeId and IMSI.mIMSI=200001311;

This query takes 2,5 sec (2500 ms) to execute. My test database is really small (1000 records). I tested some modifications in the where section but the execution time doesn't differ very much.

A single query with one table needs 30-40 ms (from the application side). Did I something wrong or is this the normal behaviour ?

We use MySQL Cluster 4.1.12 on a 2 machines Sun Solaris 10 cluster.

Joerg Nowak