Re: mysql question
| From: | Alberto Serra | Date: | Thu, 11 Jul 2002 22:09:28 +0000 |
| Subject: | Re: mysql question | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-107244@lists.php.net to get a copy of this message | ||
Привет!
1LT John W. Holmes wrote:
How about SELECT * FROM table WHERE $current_shot BETWEEN start_shot AND end_shot*if* that was on Oracle *and* the table was big you'd notice that your performance goes down. Don't ask me why. And I never checked it on MySql. But watch out for betweens. Check them. пока Альберто Киев @-_=}{=_-@-_=}{=_-@-_=}{=_-@-_=}{=_-@-_=}{=_-@-_=}{=_-@-_=}{=_-@ LoRd, CaN yOu HeAr Me, LiKe I'm HeArInG yOu? lOrD i'M sHiNiNg... YoU kNoW I AlMoSt LoSt My MiNd, BuT nOw I'm HoMe AnD fReE tHe TeSt, YeS iT iS ThE tEsT, yEs It Is tHe TeSt, YeS iT iS ThE tEsT, yEs It Is.......