Re: Slow simple query in 4000000 records table

[Matias Burak]

I'm sorry but the query is different than the one I posted before:

SELECT node_id FROM tipete_home FORCE INDEX (datetime_r_nid) LIMIT 4023950, 50


We're forcing that index instead of ordering by datetime DESC because we thought it was more optimal.



mysql> EXPLAIN SELECT node_id FROM tipete_home FORCE INDEX (datetime_r_nid) LIMIT 4023950, 50 \G;
*************************** 1. row ***************************
id: 1
select_type: SIMPLE
table: tipete_home
type: index
possible_keys: NULL
key: datetime_r_nid
key_len: 9
ref: NULL
rows: 4237955
Extra: Using index
1 row in set (0.00 sec)