之前没接触过大量的数据采集,望指导!
我目前用Access采,会丢数据,0.1s一次都做不到。
想请问下,TXT,Excel,Access 采,哪个速度最快?
采集的时候,假如我存Access, 我想到的是下面几种
这三种方式哪个最快(存Excel也是同理有3种方式)?
附上目前采集的代码段,计时器100ms触发
Private Sub 保存数据(ByVal Station As String, ByVal Force As Double)
Dim recorderTime As DateTime = DateTime.Now
' 判断如果新的一天,新建当天的文件
If System.IO.File.Exists("C:\DATA\" & recorderTime.ToString("yyyyMMdd") & ".mdb") = False Then
System.IO.File.Copy(Application.StartupPath & "\BLANK.MDB", "C:\DATA\" & recorderTime.ToString("yyyyMMdd") & ".mdb")
End If
Dim CommandString As String = String.Empty
CommandString &= "Insert INTO data(日期,时间,工位号,压力) Values("
CommandString &= "'" & recorderTime.ToString("yyyy-MM-dd") & "',"
CommandString &= "'" & recorderTime.ToString("HH:mm:ss") & "',"
CommandString &= "'" & Station & "',"
CommandString &= "'" & Force & "')"
Dim DatabaseConnection = New System.Data.OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\DATA\" & recorderTime.ToString("yyyyMMdd") & ".mdb;")
Dim DatabaseCommand = New System.Data.OleDb.OleDbCommand(CommandString, DatabaseConnection)
Try
DatabaseConnection.Open()
DatabaseCommand.ExecuteNonQuery()
DatabaseConnection.Close()
DatabaseCommand.Dispose()
DatabaseConnection.Dispose()
Catch ex As Exception
End Try
End Sub
有一些问题想要和你确认一下: