乐码库:一个极速、放心、纯净的下载站! 更新: 资源发布
  • 您的位置:首页 > 技术文档 > 数据库 > php+mysql prepare 与普通查询的性能对比实例讲解
  • 收藏本页
      php+mysql prepare 与普通查询的性能对比实例讲解
      发布时间:2016-12-21 08:08:09 关键词: php+mysql,prepare,与普通查询的性能对比,php+mysql,prepare,与普通查询的性能对比实例代码
      内容简介:prepare可以解决大访问量的网站给数据库服务器所带来的负载和开销,本文章通过实例向大家介绍预查询prepare与普通查询的性能对比,需要的朋友可以参考一下

    php+mysql prepare 与普通查询的性能对比

    实例代码如下:

    <?php 
    class timer {   
        public $StartTime = 0;   
        public $StopTime = 0;   
        public $TimeSpent = 0;   
          
        function start(){   
          $this->StartTime = microtime();   
        }   
          
        function stop(){   
          $this->StopTime = microtime();   
        }   
          
        function spent() {   
          if ($this->TimeSpent) {   
          return $this->TimeSpent;   
     
          } else {  
            // http://www.manongjc.com
            $StartMicro = substr($this->StartTime,0,10);   
            $StartSecond = substr($this->StartTime,11,10);   
            $StopMicro = substr($this->StopTime,0,10);   
            $StopSecond = substr($this->StopTime,11,10);   
            $start = floatval($StartMicro) + $StartSecond;   
            $stop = floatval($StopMicro) + $StopSecond;   
            $this->TimeSpent = $stop - $start; 
             
          return round($this->TimeSpent,8).'秒';   
          }  
        }  
      
    } 
     
    $timer = new timer;   
    $timer->start();  
     
    $mysql = new mysqli('localhost','root','root','ganbaobao_ucenter'); 
     
    /* 
    $query = $mysql->query("select username,email from uc_members where uid < 100000"); 
    $result = array(); 
    http://www.manongjc.com/article/1194.html
    while($result = $query->fetch_array()) 
    { 
      $result[] = array('name'=>$result['username'],'email'=>$result['email']); 
    } 
    */ 
    $query_prepare = $mysql->prepare("select username,email from uc_members where uid < ?"); 
     
    $id = 100000; 
    $query_prepare->bind_param("i",$id); 
     
    $query_prepare->execute(); 
    $query_prepare->bind_result($username,$email); 
     
    $result = array(); 
    while($query_prepare->fetch()) 
    { 
      $result[] = array('name'=>$username,'email'=>$email); 
    } 
     
    $timer->stop();  
    echo '</br>预查询mysql运行100000条数据时间为: '.$timer->spent();  
    unset($timer);  
    //var_dump($result); 
    

    运行结果:

    普通mysql运行1000条数据时间为: 0.011621秒

    普通mysql运行10000条数据时间为: 0.07766891秒

    普通mysql运行100000条数据时间为: 0.10834217秒

    预查询mysql运行1000条数据时间为: 0.00963211秒

    预查询mysql运行10000条数据时间为: 0.04614592秒

    预查询mysql运行100000条数据时间为: 0.05989885秒

    感谢阅读,希望能帮助到大家,谢谢大家对本站的支持!

      最新更新
      热门排行榜