0

Hi,

I did an example to see the time it takes to run a query and cache it but it doesn’t work and I cannot find why. Please give me a hand. No cache file gets created as well.

In config/database.php:
I’ve set $db[‘default’][‘cache_on’] = FALSE; because I don’t want to cache every queries.
I’ve set $db[‘default’][‘cachedir’] = ‘application/cache’; to store cache files.

Thanks in advance

VIEW : cache_view.php

<html>
<head>
<title><?php echo $title; ?></title>
</head>
<body>
    
    <h1><?php echo $heading; ?></h1>
    
    <?php echo anchor('cache/benchmark_cache', 'Start query benchmark'); ?>

</body>
</html>

CONTROLLER : cache.php

<?php if (! defined('BASEPATH')) {    exit('No direct script access allowed'); } ?>


<?php
class Cache extends CI_Controller {
    
    public function __construct()
    {
        parent::__construct();
        
        // Helper for <a...></a>
        $this->load->helper('url');
    }
    
    public function index()
    {
        // Webpage basics
        $data['title'] = "Cache";
        $data['heading'] = "Cache Benchmark checking";
        
        $this->load->view('cache_view.php', $data);
    }
    
    public function benchmark_cache()
    {
        // Webpage basics
        $data['title'] = "Cache";
        $data['heading'] = "Benchmark result";

        // Load model for db processes
        $this->load->model('cache_model');
        
        $this->benchmark->mark('code_start');
        
        $data['queryresult'] = $this->cache_model->get_benchmark();
        //sleep(5);

        $this->benchmark->mark('code_end');
        

        echo $this->benchmark->elapsed_time('code_start', 'code_end');

    }
}

//** EOF

MODEL : cache_model.php

<?php if (! defined('BASEPATH')) {    exit('No direct script access allowed'); } ?>


<?php
class Cache_model extends CI_Model {
    
    public function __construct()
    {
        parent::__construct();
        
        $this->db->protect_identifiers('assessment');
    }
    
    public function get_benchmark()
    {
        $this->db->cache_on();
        
        $sql = "SELECT * FROM assessment ORDER BY 2";
        $data['dbquery'] = $this->db->query($sql);
        
        return $data['dbquery'];
    }
}

//** EOF
1
Contributor
1
Reply
2
Views
6 Years
Discussion Span
Last Post by veledrom
0

Forgot to mention in subject. This is a Codeigniter example.

Edited by veledrom: ..

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.