Hello every body,
I have db3 file and one table with 170000 record on it.
I use dataReader and executereader for reterive records from that table.
executereader do it's job in 7 ms. But when I use loop to read record I lost many time (3000 ms).
How I can speed up this job? I need very speedy reterive.
< ---------------------------------
Dim _sqlCmd As New SQLite.SQLiteCommand(strCmd, SqliteConn)
liteDbConn.OpenConnection()
Try
_dataReader = _sqlCmd.ExecuteReader(CommandBehavior.Default)
Catch ex As Exception
Return False
End Try
Return True
<---------------------------------- In this I lost many times
While _repFetch AndAlso _dataReader.Read()
.
.
.
End While