Abstract:

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.

Key words: DataSet, bulk data, database connection