RES: RES: Mutiple SQL request

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Thank i'll try these to see the perfomance..

Thanks

Zechim

-----Mensagem original-----
De: Jim Lucas [mailto:lists@xxxxxxxxx] 
Enviada em: quarta-feira, 4 de fevereiro de 2009 16:11
Para: Jônatas Zechim
Cc: 'Bastien Koert'; php-general@xxxxxxxxxxxxx
Assunto: Re: RES:  Mutiple SQL request

Jônatas Zechim wrote:
> Can you dump the table structure to show us how you've set it up?
>  
> Bastien
> 
> Cat, the other other white meat
> 
>  
> 
> Yeah, that’s it:
> 
>  
> 
> CREATE TABLE `ctalk_admin` (
> 
>   `admin_id` int(9) NOT NULL auto_increment,
> 
>   `admin_nome` varchar(50) NOT NULL,
> 
>   `admin_login_nome` varchar(32) NOT NULL,
> 
>   `admin_pass` varchar(32) NOT NULL,
> 
>   `admin_login` int(10) NOT NULL,
> 
>   `admin_lastping` int(10) NOT NULL,
> 
>   PRIMARY KEY  (`admin_id`),
> 
>   KEY `admin_lastping` (`admin_lastping`)
> 
> ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
> 
>  

I would add a second column to that admin_lastping KEY

KEY `admin_lastping` (`admin_lastping`, `admin_id`)

Since you are using both columns in your where clause, they both need to be specified /in the same/ index for and index to be used.

Otherwise, some random index might be used.  But you will get the best performance if both are listed in the same index.

-- 
Jim Lucas

   "Some men are born to greatness, some achieve greatness,
       and some have greatness thrust upon them."

Twelfth Night, Act II, Scene V
    by William Shakespeare


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux