select with Binary running very slow in Cluster
Posted by:
Li Ma
Date: September 05, 2006 05:46AM
If add binary choice, the select query will be much slower
mysql> SELECT * FROM members WHERE binary username = 'aaa' ;
...
1 row in set (19.20 sec)
mysql> SELECT * FROM members WHERE username = 'aaa' ;
...
1 row in set (0.00 sec)
the table contains 274681 rows totally.
Mysql Version: 5.1.11
Subject
Views
Written By
Posted
select with Binary running very slow in Cluster
3139
September 05, 2006 05:46AM
1671
September 05, 2006 06:26PM
2285
September 05, 2006 07:31PM
1445
September 05, 2006 08:14PM
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.