using MySQL cache query with codeigniter

Question

I am using codeigniter with MySQL.

One of my database is a price_table that is quite constant and gets "SELECT" quite often, the access where through the same model_function, so the query would be exactly the same. I think this should be a good example to implement MySQL cached query to improve performance.

I want to use codeigniter function to interact with database as much as possible, so I have codes like:

$q = $this->db->select('service_info.*, service_pricing.price, service_pricing.price_ID')
                    ->from('service_pricing')
                    ->where('status','active')
                    ->join('service_info','service_info.service_ID = service_pricing.service_ID ')
                    ->get();
if ($q->num_rows > 0) {
    return $q->result_array();
} else {return FALSE;}

I read about the Database Caching Class from codeigniter document, but I do not think this is what I want. The cache described here seems like a global one. In my case, I want it to be a few queries about a relatively constant database.

I am thinking something like this example:

SELECT SQL_CACHE id, name FROM customer;

Is there a good way I can do it in codeigniter? Thanks!

Have you tried my answer? It must work

Rejoanul Alam
– Rejoanul Alam

2015-04-11 19:56:34 +00:00
Commented Apr 11, 2015 at 19:56 — Rejoanul Alam
– Rejoanul Alam, Commented Apr 11, 2015 at 19:56

Rejoanul Alam · Accepted Answer · 2015-04-11 19:48:41Z

1

You may set cache either global or specific to particular query. If you want to set cache to a query then use like following

$this->db->cache_on();
//your number 1 query here. this query will cache


 $this->db->cache_off();
 // number 2 query here. This query will not cached

hope clear now

answered Apr 11, 2015 at 19:48

Rejoanul Alam

5,4004 gold badges42 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

using MySQL cache query with codeigniter

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related