[PHP] Re: Help - need to quickly optimize a record count!

* Brian Dunning <[EMAIL PROTECTED]>: > 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 MyS

[PHP] Re: Help - need to quickly optimize a record count!

Brian Dunning <[EMAIL PROTECTED]> wrote on 07/06/2005 04:43:11 PM: > 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

[PHP] Re: Help - need to quickly optimize a record count!

Or even make .txt file with the cron and just include that txt file in your php Then in backgrond with perl(php) and cron you will udate that .txt file :-) So it will be 1 quesry per 15 minutes :-) Peter [EMAIL PROTECTED] wrote: Brian Dunning <[EMAIL PROTECTED]> wrote on 07/06/2005 04:43:11