Re: MySQL performance question
| From: | Lars Olsson | Date: | Mon, 05 Aug 2002 08:15:52 +0000 |
| Subject: | Re: MySQL performance question | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-111184@lists.php.net to get a copy of this message | ||
Richard Lynch wrote:
Try it and see. MySQL has a very nice 'explain' (?) or something like that built-in which will analyze your queries and tell you more than you ever wanted to know about their efficiency. http://mysql.com Note that you didn't say whether you had made an index (aka key) for this column, which may affect your answer. Also note that you're wasting your time with this question unless you have a *LOT* of rows. I mean a *LOOOOOOT* of rows. Try it and see.Cool. I didn't know about the explain command. Thanks a lot, Richard (and all else who answered)! /lasso (lasso@lassoweb.nu)