Re: Slow simple query in 4000000 records table
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)
Subject
Views
Written By
Posted
4073
November 24, 2010 04:56PM
1877
November 26, 2010 08:02AM
2751
November 27, 2010 01:42PM
2192
November 29, 2010 09:16AM
1891
November 29, 2010 10:55AM
1926
November 30, 2010 05:43AM
Re: Slow simple query in 4000000 records table
1861
November 30, 2010 08:11AM
2540
November 30, 2010 09:50AM
1887
November 30, 2010 10:06AM
1844
December 01, 2010 12:32AM
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.