Mysql插入数据100条用8s怎么办，为什么啊。。

用js写的    Mysql 插入数据 100条用8s 怎么办啊啊啊啊啊  

代码如下：

function insertComment(comments, weiboid){

    var conn = new Jaxer.DB.MySQL.Connection({

        HOST: 'localhost',

        PORT: '3306',

        USER: 'root',

        PASS: 'admin',

        NAME: 'sinaweibo',

        CLOSE_AFTER_EXECUTE: true

    });

    var count = 0, statement = "", f_statement = "",u_statement = "", times = 0, ttimes = 0,utimes = 0;//初始化

    for (var one in comments) {

        var f_count = 0, b_count = 0;

        var c_time = new Date(comments[one].created_at);

        var i_time = new Date();//当前时间

       f_count = Is_Num2(comments[one].followers_count);

        c_time = formatDate2(c_time);

        i_time = formatDate2(i_time);

        if (getCommentData(comments[one].id)) {

            if (times == 0) {

                Statement = "('" + c_time + 

				"','" + i_time + 

				"','" + comments[one].id + 

				"','" + comments[one].mid +

				"','" + comments[one].idstr +

                "','" + comments[one].text +

				"','" + comments[one].userid +

				"','" + comments[one].username +

				"','" + comments[one].followers_count +

				"','" + comments[one].weiboid +



                "')";

                times = 1;

            }

            else {

                statement += ",('" +

                c_time +

		"','"+ 

		i_time +

                "','" +

                comments[one].id +

                "','" +

                comments[one].mid +

                "','" +

                comments[one].idstr +

                "','" +

                comments[one].text +

		"','" +

		comments[one].userid +

		"','" +

		comments[one].username +

		"','" +

		comments[one].followers_count +

		"','" +

		comments[one].weiboid +

                "')";

            }

            count++;//评论数

        }



    }

    try {

 [code=Javascript][code=Javascript]

[/code]if (times != 0) {//至少有开头
var result = conn.execute("insert into comment(created_at,insert_at, commentid, mid, idstr, text,userid,username,followers_count,weiboid) values " + statement);
}
return count;
} 
catch (e) {
count = -1;
return count;

}

}[/code]

9 个解决方案