Best regards
--
Avenger <[EMAIL PROTECTED]>
Exceed PHP (http://www.phpe.net)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
but if my table is sooo big..
eg if large than 1 G. so use the mysqldump is more and more slowly
speed.
"Hans van Dalen" <[EMAIL PROTECTED]>
??:[EMAIL PROTECTED]
> Read the manual at the section:
>
> Disaster Prevention and Recovery
>
>
> Database Backups
>
E article
> ADD INDEX (ClassID, Auditing, CreatedTime, ArticleID);
>
> And then the query should only use the index for execution. Then you can
> of course run the second query to get all columns you want:
>
> SELECT * FROM article WHERE ArticleID IN ( ArticleIDs from first query
e (CreatedTime),
) TYPE=MyISAM ;
My query: "SELECT ArticleID FROM article WHERE ClassID = 101 AND Auditing =
1 ORDER BY CreatedTime DESC LIMIT x , y"
I allreday created the key1 and the CreatedTime key. And it's even
slowly now ... :(
Avenger
""Matt W"" <
index which is
> much faster than scanning the data file.
>
> SELECT id FROM table ORDER BY id LIMIT 150, 20;
>
> Then take the first and last of those ids and run this query to get the
> other columns:
>
> SELECT * FROM table WHERE id BETWEEN @low_id AND @high_id ORDER BY id;
Does mysql do any optimization for then one use
`select ... limit x,y`?
For example, I have table with 200 records and want to do page web
interface to this table.
When i use `select ... from table limit 150, 20 `, it will need more and
more times (on my here is more than 60 sec).
well,
