|
|
Posted by Brian Dunning on 07/07/05 00:15
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, 6 Jul 2005, 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 my ISP because this query was
>> causing resource issues, so I need to find a different way to know
>> the record count in that table. A few records are added once every
>> 5 minutes by a cron job. The record count is constant the rest of
>> the time. No records are ever deleted.
>>
>> Is it possible to create some kind of server-side variable, in
>> which the cron job could store the record count, which would be
>> accessible to all scripts, and would stay the same until it gets
>> reset? Or is there a less-intense MySQL query I should be using
>> instead?
>>
>> Thanks in advance for any suggestions.
>>
>> --
>> PHP General Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>
Navigation:
[Reply to this message]
|