Re: MySQL performance question

From: 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)

« previous php.general (#111184) next »