more complex queries on clusters
Posted by:
Jörg Nowak
Date: September 13, 2005 02:26AM
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
Subject
Views
Written By
Posted
more complex queries on clusters
2565
September 13, 2005 02:26AM
1756
September 13, 2005 09:07AM
1644
September 13, 2005 10:52PM
1756
September 14, 2005 03:51AM
1600
September 19, 2005 06:31AM
1551
September 19, 2005 07:05AM
1530
September 19, 2005 07:17AM
1692
September 19, 2005 07:37AM
1597
September 19, 2005 07:51AM
1542
September 19, 2005 08:15AM
1626
September 19, 2005 08:19AM
1626
September 19, 2005 08:22AM
1448
September 19, 2005 08:34AM
1626
September 19, 2005 08:46AM
1551
September 14, 2005 01:10AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.