douyuliu9527
2016-01-29 11:57
浏览 53
已采纳

如何使用codeigniter优化活动记录?

i have a problem whit a error: maximum size of arrays in php, $ids has a maximum and i don't know how to resolve it. Array size is limited only by amount of memory your server has. I 'll get out of memory" error and i can not change php.ini I need optimize this funcctions, some idea ?

function delete_ScormByIdPlataforma($idPlatforma)
    {       
        if ($this->getIdScormVarsToDelete($idPlatforma) != 0)
        {
            $ids = $this->getIdScormVarsToDelete($idPlatforma);
            $this->db->where_in('ID_dispatch', $ids);
            $this->db->delete('scormvars');
        }//else
        //log_message('error', 'No se han encontrado scorms a borrar'.$this->db->_error_message().' - '.$this->db->last_query());
    }



function getIdScormVarsToDelete($idPlataforma)
    {
        $this->db->select('s.ID_dispatch');
        $this->db->from('scormvars as s');
        $this->db->join('dispatch as d', 's.ID_dispatch = d.ID_dispatch', 'INNER');
        $this->db->join('licencias as l', 'd.ID_licencia = l.ID_licencia','INNER');
        $this->db->where('l.id_plataforma', $idPlataforma);

        $query = $this->db->get();

        if($query)
        {
            if($query->num_rows()>0){
                foreach ($query->result() as $fila){
                    $data[] = $fila->ID_dispatch;
                }
                return array_unique($data);
            }
        }
        else
        {
            //log_message('error', 'No se han encontrado Dispatch a borrar'.$this->db->_error_message().' - '.$this->db->last_query());
            return 0;
        }
    }

图片转代码服务由CSDN问答提供 功能建议

我遇到错误问题:php中数组的最大大小,$ ids有最大值而且我不知道 知道如何解决它。 阵列大小仅受服务器内存量的限制。 我将失去记忆“错误,我无法改变php.ini 我需要优化这个功能,一些想法?

  function delete_ScormByIdPlataforma($ idPlatforma)
 {  
 if($ this-> getIdScormVarsToDelete($ idPlatforma)!= 0)
 {
 $ ids = $ this-> getIdScormVarsToDelete($ idPlatforma); 
 $ this-> db-> where_in(  'ID_dispatch',$ ids); 
 $ this-> db-> delete('scormvars'); 
} // else 
 // log_message('error','No se han encontrado scorms a borrar  '。$ this-> db-> _error_message()。' - '。$ this-> db-> last_query()); 
} 
 
 
 
函数getIdScormVarsToDelete($ idPlataforma)\  n {
 $ this-> db-> select('s.ID_dispatch'); 
 $ this-> db-> from('scormvars as s'); 
 $ this-> db  - > join('dispatch as d','s.ID_dispatch = d.ID_dispatch','INNER'); 
 $ this-> db-> join('licencias as l','d.ID_licencia =  l.ID_licencia','INNER'); 
 $ this-> db-> where('l.id_plataf  orma',$ idPlataforma); 
 
 $ query = $ this-> db-> get(); 
 
 if if($ query)
 {
 if if($ query-> num_rows(  )> 0){
 foreach($ query-> result()as $ fila){
 $ data [] = $ fila-> ID_dispatch; 
} 
返回array_unique($ data); \  n} 
} 
其他
 {
 // log_message('error','No se han encontrado Dispatch a borrar'。$ this-> db-> _error_message()。' - '。$ this  - > db-> last_query()); 
返回0; 
} 
} 
   
 
  • 写回答
  • 好问题 提建议
  • 追加酬金
  • 关注问题
  • 收藏
  • 邀请回答

2条回答 默认 最新

  • dqo88037 2016-01-29 15:20
    已采纳

    It's in way you pass data and way you write codes. So If there are lot of joins or some bigger function you can switch it to SP(Stored Procedure).

    And you can check your query speed by

    Enable Profiler in your __construct

    $this->output->enable_profiler(TRUE);
    

    And in your code

    $this->benchmark->mark('my_mark_start'); # my_mark_start can set any name with _start/ generate_start
    $data['some_name'] = $this->model_name->modelFunctionName();
    $this->benchmark->mark('my_mark_end'); # generate_end
    

    This will shows how much your code took took to proceed the data

    评论
    解决 无用
    打赏 举报
查看更多回答(1条)

相关推荐 更多相似问题