iOS的sqlite3大量数据插入数据库操作

- (void)insertData:(NSString *)paramString
{
    [self readyDatabase];
    if (sqlite3_open([databasePath UTF8String], &database) == SQLITE_OK)
    {
        char *errorMsg;
        sqlite3_exec(database, "BEGIN TRANSACTION;", 0, 0, &errorMsg);
        if (SQLITE_OK != sqlite3_exec(database, [paramString UTF8String], nil, nil, &errorMsg))
        {
            NSLog(@"Insert failed.");
            sqlite3_exec(database, "ROLLBACK;", 0, 0, &errorMsg);
        }
        sqlite3_exec(database, "COMMIT TRANSACTION;", 0, 0, &errorMsg);
    }
    sqlite3_close(database);
    NSLog(@"Insert data success");
}