Re: Bad performance?

[Jacob Christensen]

Sorry about that, it was because i changed som of the names... The table really loks like this:

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

I all ways use explain to see if I use indexes, it was the first I look at and it was okay!

Any other ideas?