Re: MySQL Cluster performance question

> mysql> SELECT DISTINCT gv_symbol FROM `past30_ndb_disk` FORCE INDEX
> (`gvsymtime`) WHERE 1;
> 90 rows in set (4 min 44.90 sec)
>
> mysql> SELECT DISTINCT gv_symbol FROM `past30_MYISAM` FORCE INDEX
> (`gvsymtime`) WHERE 1;
> 90 rows in set (1.54 sec)

Can we see the create table on these? Frankly, the 1.54 seconds on the myisam seems low to me if a good key is used.

-- 

Brian Moon
Senior Developer
------------------------------
http://dealnews.com/
It's good to be cheap =)

-- 
MySQL Cluster Mailing List
For list archives: 
http://lists.mysql.com/cluster
To unsubscribe:    
http://lists.mysql.com/cluster?unsub=lists@pantek.com