; From: Burhan 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-post
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 m
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,
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 c
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...
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 que
6 matches
Mail list logo
