How to speed up inserting records into MySQL Server 5.5
-
Please tell me how i can maximize the number of inserted records.
At this point the speed inserting 4000 records per second:
@
queryStringJAN = "INSERT INTO january";
queryStringJAN = queryStringJAN + " (answer,dateOfCall,timeOfCall,phoneNumberA,phoneNumberB,callDuration,offset) VALUES ";
queryStringJAN.append( QString( "(?,?,?,?,?,?,?)," ).repeated( 1000 ) );
queryStringJAN.chop( 1 );
if( !queryJAN.prepare( queryStringJAN ) )
{
qDebug() << "Unable to prepare query:" << query.lastError();
return FALSE;
}@
@
if (numCurrRecPrepared == 1000)
{
if( !queryJAN.exec() )
{
//qDebug() << "Unable to exec query:" << query.lastError();
//
return 0;
}
}
@