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

2005-07-06 Thread Matthew Weier O'Phinney
* 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 MySQL account

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

2005-07-06 Thread SGreen
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 `count`

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

2005-07-06 Thread Peter
Or even make .txt file with the cron and just include that txt file in your php ? include_once('figures.txt'); ? 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