Re: Caching query results in html pages

I believe a much better solution would be to use MySQL Query Cache. http://dev.mysql.com/doc/refman/5.0/en/query-cache.html Use it wisely and there is a lot of performance gain. Donot simply enable cache for all sql statements. Amit. On 3/13/07, Micah Stevens <micah@raincross-tech.com> wrote:

This may work, although I just made it up. I can see already that you'd have some problems with multiple scripts running at once. If a script opens the cache, then a second script saves new cache information before the first script saves it's data, the first script would overwrite the second script's update. Maybe instead of a read at the beginning of script execution, a read at the beginning of each query would be better? Save cache results to a file: <? // script start $querycache = unserialize(file_get_contents("query.cache")); /* $querycache format: array('sql' => array(), 'result'=>array(), 'time'=>array()); For each sql statement 'sql' you have a result array. */ // run all your queries through a function: function query($sql) {

    $cached = array_search($sql, $querycache['sql'])
    // check to see if the result is old
    if (time() - $querycache['time'][$cached] > $max_time) {
          unset($querycache['time'][$cached]);
          unset($querycache['sql'][$cached]);
          unset($querycache['result'][$cached]);
          $cached = false;
    }
    if ($cached) {
          return $querycache['result'][$cached];
    } else {
          $result = mysql_query($sql);
          $querycache['sql'][] = $sql;
          $index = array_search($querycache['sql']);
          $querycache['time'][$index] = time();
          while ($r = assoc($result)) {
                 $querycache['result'][$index][] = $r;
          }
          // save cache for other scripts
          file_put_contents('query.cache', serialize($querycache));
          return $querycache['result'][$index];
    }

} ... It's actually kind of a complicated process now that I'm thinking about it. -Micah On 03/13/2007 06:20 AM, Vincent wrote: Hi all, I'm trying to improve the performance for visitors, and I want to know if there is some way to store the mySQL results of .php scripts in webpages. So, in example, when requesting http://www.mydomain.com/script.php?id=110 , it can be redirected to his cached version http://www.mydomain.com/id110.html. Any code or information would be appreciated, Regards, -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php