php - CodeIgniter $db query optimization -


i have problem query generated in following method:

function most_visited($hrs=1,$cat_id=null,$limit=20){     $date = strtotime('- '.$hrs.' hours');     $date = date('y-m-d h:i:s',$date);     $this->db->select('count(content_id) otvaranja, title, id, cat_id, date_start,published,komentari,pocount,postatus ');     $this->db->join('news','news.id=stats.content_id','inner');     $this->db->limit($limit);     if($cat_id !== null){         if(is_array($cat_id)){             $this->db->where_in('cat_id',$cat_id);         } else {             $this->db->where('cat_id',$cat_id);         }     }     $this->db->where('date >=',$date);     $this->db->where('content_type','news');     $this->db->having('otvaranja>=',1,false);     $this->db->group_by('content_id');     $this->db->order_by('otvaranja','desc');     return $this->db->get('stats')->result(); }

it's killing database.

any suggestions on how alter , make faster?


Comments

Post a Comment

Popular posts from this blog

c# - Operator '==' incompatible with operand types 'Guid' and 'Guid' using DynamicExpression.ParseLambda<T, bool> -

i'm using dynamic linq library , there source code , basic docu , nuget version pm> install-package dynamiclinq i'm trying construct clause involves guids i have tried string "id == @0" . parameter array object[] value ( guid xxxx ) var whereclausesb = buildlogicalkeywhereclause2(entity, logicalkey); //build string var parms = buildparamarray(entity, logicalkey); // object[] var wherelambda = ofsi.bos.core.dynamicexpression.parselambda<t, bool>(whereclausesb.tostring(),parms); //parse an exception thrown in dynamicexpression.parselambda operator '==' incompatible operand types 'guid' , 'guid' i have tried guid , string.(fail) i tried , "id = @0" (fail). string == string works, int32==int32 not guid == guid not any ideas? try using equals method instead of == operator in string: "id.equals(@0)"
Read more

matlab - How to equate a structure array to structure array -

the following code doesn't work, think it's clear want do: my.struct = 1; foo.bar = my.struct; so that foo.bar.struct = 1 basically want fill in my structure array bunch of fields , values. want place struct nested struct within foo.bar while retaining field names. my.struct = 1; foo.bar = my.struct; this places value of my.struct (= 1 ) in foo.bar . of course foo.bar 1 . i think you're after this: my.struct = 1 foo.bar = my;
Read more