System.Data.SQLite

Hi when i use the following code. my application spend mor than 8 seg updating 40 added, deleted, or changed rows in the datatable

            Using TableAdapter As New SettingsTableAdapter

                TableAdapter.Connection = DbManager.Connection

                TableAdapter.Update(SettingsTable)
            End Using

where  DbManager.Connection is the Application SQLite Connection

 thanks in advance

Manolito

Try to put multiple row operations within a transaction. See if that helps.