Re: Bad performance?

[Jacob Christensen]

Yes is was a bad select i posted. The select allways look like this:

SELECT * FROM cologin WHERE user='XXXX' and k_id='XXXX';

Explain from the select above is okay and confirm index is okay.

I even tried making a index on all the fields with the same result.

This select take 3-4 sec with no load on the cluster:

SELECT * FROM cologin LIMIT 350000, 30;

Best Regards,
Jacob