有效的方式来批量插入到的dBASE（DBF）文件 [英] Efficient way to bulk insert into Dbase (.dbf) files

问题描述

即时通讯目前使用OleDBCommand.ExecuteNonQuery（反复调用）在从源数据表一时间插入多达350,000行到dBASE文件（* .DBF）。我重新使用OleDbCommand对象，并OleDbParameters设定值在每个时插入语句被调用时插入。插入350000行目前把我的节目约45分钟。

Im currently using OleDBCommand.ExecuteNonQuery (repeatedly called) to insert as much as 350,000 rows into dbase files (*.dbf) at a time from a source DataTable. I'm reusing an OleDbCommand object and OleDbParameters to set the values to be inserted each time when the insert statement is called. Inserting 350,000 rows currently takes my program about 45 mins.

有没有更有效的方法来做到这一点？确实存在的dBASE（* .DBF）文件吗？

Is there a more efficient way to do this? Does something similar to the Bulk Insert option used in SQL Server exist for Dbase (*.dbf) files?

推荐答案

通过改变从射流的OLEDB驱动程序vfpoledb修正了问题。这种切割的总时间从40分钟到8分钟。

Fixed the problem by changing the OleDB driver from Jet to vfpoledb. This cut the total time from 40 mins to 8 mins.

在vfpoledb司机和合并模块是从链接下载以下

The vfpoledb driver and merge module was downloaded from the link below

<一个href="http://www.microsoft.com/downloads/en/details.aspx?FamilyID=e1a87d8f-2d58-491f-a0fa-95a3289c5fd4" rel="nofollow">http://www.microsoft.com/downloads/en/details.aspx?FamilyID=e1a87d8f-2d58-491f-a0fa-95a3289c5fd4

感谢您的帮助。

这篇关于有效的方式来批量插入到的dBASE（DBF）文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！