Oledbconnection在vb.net中可以处理的CSV文件的最大大小是多少? [英] What is the maximum size of CSV file in which the Oledbconnection can process in vb.net?

问题描述

亲爱的所有人，
我需要知道 csv文件的最大大小，其中 Oledbconnection 可以在VB.NET应用程序中进行处理，我可以使用具有超过12,00,000的csv文件进行测试记录，其罚款.但是，如果我给具有1crore记录的csv文件，那么我得到了内存不足的异常.请任何人帮助我做到这一点.

问候，
BlueSathish

Dear All,
I need to know the maximum size of the csv file in which Oledbconnection can process in VB.NET Application, I can tested with the csv file which has more than 12,00,000 records, its fine. but if i give the csv file which has 1crore records then i got the out of memory exception. Please anyone help me to do this.

Regards,
BlueSathish

推荐答案

对于大文件，最好使用StreamReader并缓冲数据以块"形式读取它

看一下这篇文章，其中展示了该技术(c#)

快速CSV阅读器 [

With a large file, it''s better to read it in ''chunks'' by using a StreamReader and buffering the data

Have a look at this article, which shows the technique (c#)

A Fast CSV Reader[^]

There isn''t going to be a maximum file size per se, you will be limited by the resources available on the machine running the code.

这篇关于Oledbconnection在vb.net中可以处理的CSV文件的最大大小是多少?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！