Re[2]: [PHP-DB] Optimising LIMITs - alter table order by...

2004-03-02 Thread Richard Davey
Hello Pavel, Tuesday, March 2, 2004, 12:33:17 PM, you wrote: PL http://www.mysql.com/documentation/mysql/bychapter/manual_SQL_Syntax.html#ALTER_TABLE PL ORDER BY allows you to create the new table with the rows in a specific PL order. Note that the table will not remain in this order after

Re[2]: [PHP-DB] Optimising LIMITs

2004-03-01 Thread Richard Davey
Hello Jeffrey, Monday, March 1, 2004, 5:27:41 PM, you wrote: JM Primary keys aren't any faster than normal keys. They're simply for JM identification. (correct me if I'm wrong, that is my understanding) JM If you don't already have an index on created, I'd do that. I do - here's a question

Re: Re[2]: [PHP-DB] Optimising LIMITs

2004-03-01 Thread Jeffrey Moss
JM Primary keys aren't any faster than normal keys. They're simply for JM identification. (correct me if I'm wrong, that is my understanding) JM If you don't already have an index on created, I'd do that. I do - here's a question though, what is the best way to have an index? To combine