应用开发

MySQL极限测试:索引提高的效率

时间:2010-12-5 17:23:32  作者:IT科技   来源:应用开发  查看:  评论:0
内容摘要:复制functioncre_random($nLength=4) { $sDic="ABCDEFGHIJKLMNOPQRSTUVWXYZ"

MySQL极限测试:索引提高的效率
复制function cre_random($nLength=4)   {   $sDic = "ABCDEFGHIJKLMNOPQRSTUVWXYZ" "abcdefghijklmnopqrstuvwxyz"   "1234567890";   $sDic = str_repeat($sDic,限测效率 ceil($nLength/strlen($sDic)));   $sDic = str_shuffle($sDic);   return substr($sDic, 0, $nLength);   }   set_time_limit(0);   mysql_connect("localhost","root","");   mysql_select_db("test");   while(true)   {   $sql = "insert into comment(test,tudou) values (".cre_random(10).",".cre_random(10).")";   mysql_query($sql);   }  1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.
copyright © 2025 powered by 编程之道  滇ICP备2023006006号-34sitemap