Brian Dunning wrote:
I am cross-posting this to the PHP and the MySQL lists because I'm not
sure in which technology my solution will lie.
I have a pretty busy PHP/MySQL site that executes the following query a
lot:
select count(*) as `count` from terms;
My MySQL account was disabled by
Khalid [mailto:[EMAIL PROTECTED]
Sent: Sunday, July 10, 2005 12:21 AM
To: Brian Dunning
Cc: php-general@lists.php.net; mysql@lists.mysql.com
Subject: Re: [PHP] Help - need to quickly optimize a record count!
Brian Dunning wrote:
I am cross-posting this to the PHP and the MySQL lists
I am cross-posting this to the PHP and the MySQL lists because I'm
not sure in which technology my solution will lie.
I have a pretty busy PHP/MySQL site that executes the following query
a lot:
select count(*) as `count` from terms;
My MySQL account was disabled by my ISP because this
It is indexed, and it's fast, but nevertheless my ISP won't allow it
any longer. At least not as often as I need it.
On Jul 6, 2005, at 2:10 PM, Philip Hallstrom wrote:
If you have an index on the terms table that query should return
almost instantly...
Anyway, I'd start there first...
On Wed, July 6, 2005 1:43 pm, Brian Dunning said:
I am cross-posting this to the PHP and the MySQL lists because I'm
not sure in which technology my solution will lie.
I have a pretty busy PHP/MySQL site that executes the following query
a lot:
Define a lot
Every page hit?
select count(*)
Hi Richard - like I said, whatever the merits of the situation,
that's the query that the ISP is not permitting. As soon as I change
that, they'll reactivate the account. The ISP is PowWeb if anyone
else wants to take it up with them; I've already talked myself red in
the face.
On Jul
6 matches
Mail list logo