Justtechjobs.com Find a programming school near you






Online Campus Both


php4-beta | 200004

RE: [PHP4BETA] A question about PHP and Mysql From: Michael Nino (mnino <email protected>)
Date: 04/06/00

Yes. I would look to MySQL news/support mailing list? Worse case scenario
you could maintain an auxilary table which maintained the count (number of
insertions) for every INSERT or DELETE you would update the auxilary table.
Workaround, ya know ;)

michael

-----Original Message-----
From: Alex zhang [mailto:cd_av2av2 <email protected>]
Sent: Thursday, April 06, 2000 1:06 PM
To: Michael Nino; php4beta <email protected>
Subject: RE: [PHP4BETA] A question about PHP and Mysql

I have tried it and checked it with Explain(looks
right). Same result.
It acturally occurs when you have too much entries
return in big tables
pls try!
Anyway, thanks

alex

--- Michael Nino <mnino <email protected>> wrote:
> That's more than I have ever counted. But you might
> try counting on a single
> column:
>
> select count(a) from tablea where a='tom';
>
> Or trying using EXPLAIN (see
>
http://www.mysql.com/php/manual.php3?section=EXPLAIN).
>
> good luck!
> michael
>
> -----Original Message-----
> From: Alex zhang [mailto:cd_av2av2 <email protected>]
> Sent: Thursday, April 06, 2000 7:17 AM
> To: php4beta <email protected>
> Subject: [PHP4BETA] A question about PHP and Mysql
>
>
> Hi,
> Maybe this should be a question about Mysql.But I
>
> met them in my PHP code.
> For too big table in Mysql ex 3 million rows,
> even
> you added index for some field , it is very slow
> to count rows.Like this
> select count(*) from tablea where a='tom';
> I have index for "a" field.But it always took about
> 5-7 seconds to finish such query.
> Who has idea about that?
>
> thankx in advance
>
>
> Alex
>
> __________________________________________________
> Do You Yahoo!?
> Talk to your friends online with Yahoo! Messenger.
> http://im.yahoo.com
>
> --
> PHP 4.0 Beta Mailing List
> <http://www.php.net/version4/>
> To unsubscribe, e-mail:
> php4beta-unsubscribe <email protected>
> For additional commands, e-mail:
> php4beta-help <email protected>
> To contact the list administrators, e-mail:
> php4beta-admin <email protected>
>

__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com 

-- 
PHP 4.0 Beta Mailing List <http://www.php.net/version4/>
To unsubscribe, e-mail: php4beta-unsubscribe <email protected>
For additional commands, e-mail: php4beta-help <email protected>
To contact the list administrators, e-mail: php4beta-admin <email protected>