sqlite大量数据插入优化总结

1.将插入操作放到一个Transaction里，默认的每条insert语句都会开启一个Transaction，参见:2.手动拼写插入语句，不要运用ORM，虽然代码会看起来很多，但是效率绝对大幅度提升未优化前代码:    NSArray *organizations = [organizationsDic allValues];    for (Organization *organization in organizations) {        [organization save];    }优化后代码:    //手动拼接sql语句，不采用OR模式，提升点性能，有待进入内网测试    FMDatabase *db = [MD_DataBaseTool getDb];    NSString *sql;    //保存公司或部门    [db beginTransaction];    NSArray *organizations = [organizationsDic allValues];    for (Organization *organization in organizations) {        sql = [NSString stringWithFormat:@"insert into Organization(organizationId, name, pId, memberNumber, type, sortNumber, groupId) values('%@', '%@', '%@', '%@', '%@', '%@', '%@')", organization.organizationId, organization.name, organization.pId, organization.memberNumber, organization.type, organization.sortNumber, organization.groupId];        [db executeUpdate:sql];    }    //保存用户-部门映射表    for (UserOrganizationMap *userOrganizationMap in userOrganizations) {        sql = [NSString stringWithFormat:@"insert into UserOrganizationMap(userOrganizationId, userId, organizationId, position, recentlyMap) values('%@', '%@', '%@', '%@', '%@')", userOrganizationMap.userOrganizationId, userOrganizationMap.userId, userOrganizationMap.organizationId, userOrganizationMap.position, userOrganizationMap.recentlyMap];        [db executeUpdate:sql];    }    [db commit];