Code Comments
Programming Forum and web based access to our favorite programming groups.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*.
Post Follow-up to this messagePowered by vBulletin
Copyright 2000-2006 Jelsoft Enterprises Limited.