基于强类型DataSet的批量数据导入的优化算法

针对使用强类型DataSet批量数据导入效率低下的问题, 提出了一种优化算法。在兼顾强类型DataSet节省开发时间特性的同时, 在分析强类型DataSet内部方法的工作原理基础上, 对数据库连接的状态加以控制, 使对离线数据集中的所有数据操作处于一个连接中, 从而避免了数据库连接的频繁开关操作。 实验结果表明, 数据的提取所耗费的时间远小于数据导入所用时间, 有效提高了批量数据导入效率。

Optimization Algorithm for Bulk Data Import Based on Typed DataSet

In order to solve the low inefficient problem in importing bulk data by typed DataSet, we present an optimization algorithm. Giving consideration to the quality of saving time, by analysising the working principle of the function inside the class of DataSet, we control the connection of the database, making every operation in disconnected dataset between only one database connection, avoiding frequently database operation of connections open close. Experimental results show that the time for data extraction is much less than the time for data import, and prove that the algorithm can effectively improve the efficiency of bulk data import.