Hello.
What engine do you use? 'SELECT COUNT(*) FROM TABLE_NAME' is
very optimized, however only for MyISAM tables. Have you thought about
a dedicated table for such a purposes, or adding auto_increment column to
the table?
Brian Dunning <[EMAIL PROTECTED]> wrote:
> I am cross-postin
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
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
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
