I am developing an app in VB:NET to access and modify .accdb database.
This is very heavy file (around 1GB) and I need to update it every day for around 100 times a day and around 100 queries each time.
This is making the process very slow.
Is there any possibility to speed up. Or is it possible that each time I need to update the database, I create a local copy in visual studio, then update it locally and then update the original database on server.
Here is the small sniplet of the code I am using to update database currently:
Private Sub ExecuteSQL(str As String)
cmd = New OleDbCommand(str, myConnection)
Catch ex As Exception
Log_inputstring = ("Error - " & ex.Message)
My.Computer.FileSystem.WriteAllText(LogFilePath, Log_inputstring & vbNewLine, append:=True)
Catch ex2 As Exception
Your help will really be appreciated.
With best regard's,
Last edited by pratikshah2232; 06-09-2016 at 12:03 AM.