| Bastien Koert 2004-09-30, 8:56 pm |
| The MYI file is the index file. Is there an index on that table?
>From: jgoodie@att.net (Jennifer Goodie)
>To: blackwater dev <blackwaterdev@gmail.com>
>CC: php-db@lists.php.net, Subject: Re: [PHP-DB] rand()
>Date: Wed, 29 Sep 2004 23:27:43 +0000
>
>-------------- Original message from blackwater dev : --------------
>2)
>
>perror 2 returns "Error code 2: No such file or directory"
>
>Does /var/tmp exist on the server?
>
>If you run explain on your query in both cases (with one record and with
>more than one record) you will see that when there is more than one record
>it is probably using temporary tables and file sort, but is not when
>there's only one record.
>
>--
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php
>
________________________________________
_________________________
Take advantage of powerful junk e-mail filters built on patented Microsoft®
SmartScreen Technology.
http://join.msn.com/?pgmarket=en-ca..._MSNIS_Taglines
Start enjoying all the benefits of MSN® Premium right now and get the
first two months FREE*.
|