.accdb database (1 Viewer)

pratikshah2232

New member
Joined
Jun 9, 2016
Messages
1
Hallo All,

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)
myConnection.Open()
cmd = New OleDbCommand(str, myConnection)
Try
cmd.ExecuteNonQuery()
cmd.Dispose()
myConnection.Close()
Catch ex As Exception
Log_inputstring = ("Error - " & ex.Message)
Try
My.Computer.FileSystem.WriteAllText(LogFilePath, Log_inputstring & vbNewLine, append:=True)
Thread.Sleep(200)
Catch ex2 As Exception

End Try

Application.Exit()
Process.Start(Application.ExecutablePath)
End Try
End Sub

Your help will really be appreciated.

Thank you.
With best regard's,
Pratik Shah
 
Last edited:

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom