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 though, what is the best way to have an
index? To combine multiple fields into one index - or to have one
field per index? I ask because MySQL will appear to select the best
possible index for the query and sometimes it's wrong - I read
somewhere you can control which index it uses, but if you had a
"combined" index would this make things any more/less effective?

JM> If you want to optimize things further, I would run the query at midnight
JM> each morning, and instead of paging through the entire table, just page
JM> through that temporary table.

Figured someone might suggest that - I will have to look into it.

Best regards,
 Richard Davey

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to