ado向sqlserver插入记录,效率很差?
小竹z 2015-12-08 11:32:50 RT。写了一个测试程序,使用ado接口和sql语句向sqlserver插入记录,表也就7、8列。单条插入,测试每秒插入900条。使用多线程也没咋改善。测试程序和sqlserver通过局域网网线连接。
代码如下:
string strSql;
try
{
strSql = "insert into Message(ID,Sender,Recver,Type,cType,Attach,sAddress) values(";
strSql += "'" +info.sid + "'" + ",";
strSql +=toString(info.isend) + ",";
strSql +=toString(info.irecv)+ ",";
strSql += toString(info.iType) + ",";
strSql += toString(info.iCtType) + ",";
strSql += "'" + info.sAttach + "','";
strSql+=info.sAddress+"')";
_variant_t ra;
m_pRecordset = m_pCon->Execute(strSql.c_str(), &ra, adCmdText);
}
catch (_com_error e)
{
LOG(LOGI_ERROR, strSql.c_str());
LOG(LOGI_ERROR, "向数据库写入消息记录时失败:%s" , string(e.Description()).c_str());
return false;
}