I use OLEDB to insert data to a DB4 .dbf file. Inserting 5,500 rows takes approximately 2.5 min. So I need a faster way to implement it as my data will have upto 80,000 rows and time taken will be too painful. Is there any alternative faster ways to do this? According to your view which is the best way?
PS开发者_JAVA百科: Please mention the aprox. time taken for your method if possible
Inserting multiple rows within a single query could speed up a lot your work.
For example: I've just tried inserting 100,000 rows using 100,000 INSERT and using 1,000 INSERT with 100 rows each one: I have a speed-up about 100!!
Difference is using
INSERT INTO table (....) VALUES (...)
and
INSERT INTO table (....) VALUES (...),(...),(...),(...),(...),...
So edit your inserting function to use 100 (for example) records at a time.
精彩评论