MySQL Forums
Forum List  »  NDB clusters

Re: Bad performance?
Posted by: Jacob Christensen
Date: December 08, 2004 02:44PM

Now table look like this:

CREATE TABLE `cologin` (
`id` int(10) unsigned NOT NULL auto_increment,
`kampagne_id` int(4) unsigned NOT NULL default '0',
`brugernavn` varchar(32) NOT NULL default '',
`tilmeldt` enum('y','n') NOT NULL default 'n',
`unixtimestamp` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `kampagne_id` (`kampagne_id`),
KEY `brugernavn` (`brugernavn`),
KEY `id` (`id`),
KEY `kampagne_id, brugernavn` (`kampagne_id`,`brugernavn`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1 AUTO_INCREMENT=392152 ;

SELECT * FROM cologin WHERE kampagne_id = '9' and brugernavn = 'test'; (query time 0,3-0,4 sec.)

SELECT * FROM cologin WHERE brugernavn = 'test'; (query time 0,00019 sec.)

This time I even did the select from an API on the same com as the db node.

Options: ReplyQuote


Subject
Views
Written By
Posted
4191
December 06, 2004 06:33PM
2870
December 06, 2004 09:13PM
2828
December 07, 2004 07:18AM
2633
December 07, 2004 11:58AM
2836
December 07, 2004 01:19PM
3699
December 07, 2004 06:22PM
2725
December 08, 2004 01:33PM
Re: Bad performance?
3611
December 08, 2004 02:44PM
2819
December 09, 2004 10:05AM


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.