谁能帮我解释一下每二个for循环的200是什么意思,还有它的性能如何能提高些呢??比如,我想每秒入库20000条,而现在才1000条!
APIRETURN insert(void * para)
{
MYSQL * m_connptr1;
for(;
{
for(int i = 0;i < 200;++i)
{
CMysqlClient client;
CMysqlStore store;
if(!store.SetTransAction(client.GetConnect())){
std::cout<<"db connect pool busy on insert"<<endl;
break;
}
std::string s_sql = "";
s_sql = "insert into lzs";
s_sql += "(acttype,resourceid,actresult,memo) values(";
s_sql += "1,1,1,'发的沙')";
if(!store.Exec(s_sql)){
//执行SQL语句出错
store.RollBack();
std::cout<<"execute insert syntax fail,"<<store.What().c_str()<<endl;
} else{
store.Commit();
}
}
#ifdef WIN32
Sleep(DWORD(1000 * 0.01));
#else
sleep(1);
#endif
}
return 0;
} |
