slow.log:
# Query_time: 14 Lock_time: 0 Rows_sent: 30 Rows_examined: 771327
SELECT * FROM `post` LIMIT 771297, 30;
i dp have privmary key on table `post`
does 'Rows_examined: 771327' means mysqlserver read through those 771327
rows to get 30 rows?
it takes 14 seconds!
possible to show
hrm.. but i tried
SELECT * FROM post ORDER BY postdate DESC LIMIT 771297, 30
postdate is not primary key but just an INDEX
it still examined 771297 rows
From: Michael Stassen [EMAIL PROTECTED]
To: tinys xuefer [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: what does Rows_examined mean