Re: [Maria-discuss] MariaDB subquery

2014-04-01 Thread James Qian Wang
On Mon, Mar 31, 2014 at 9:33 AM, James Qian Wang wrote: > Hi All, > > Here is the table structures and query: > > CREATE TABLE `c` ( > `cid` int(10) unsigned NOT NULL AUTO_INCREMENT, > `c_outcome` int(10) DEFAULT NULL, > KEY `c_outcome` (`c_outcome`), > PRIMARY KEY

Re: [Maria-discuss] MariaDB subquery

2014-03-31 Thread James Qian Wang
to resolve this by tweaking /etc/my.cnf? Or this needs code changing? Thanks a lot in advance James On Mon, Mar 24, 2014 at 9:46 AM, Reindl Harald wrote: > > > Am 24.03.2014 10:01, schrieb James Qian Wang: > > I have a query which shows type REF when explained in MySQL 5.5/5.6. &

[Maria-discuss] MariaDB subquery

2014-03-24 Thread James Qian Wang
Hi All, I have a query which shows type REF when explained in MySQL 5.5/5.6. However, the same query shows type INDEX in MariaDB 10.0.9 I.e. the query is a lot slower in MariaDB. Any one has the similar experience please? Please drop me a line. -- James Qian Wang

[Maria-discuss] subscribe please

2014-03-21 Thread James Qian Wang
-- James Qian Wang Mobile: 44 7986 099 233 ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp