Slow simple query in 4000000 records table

[Matias Burak]

Hi guys,

We have a table where we've already reached 4 million records. The problem is that doing just something like:

SELECT * FROM table LIMIT 100000,50

is taking between 40 and 65 seconds.

Is this amount of records something that MySQL can't manage?

I need help with this.

Thanks!

Matias.