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;
    }
    }
    @


Log in to reply
 

Looks like your connection to Qt Forum was lost, please wait while we try to reconnect.