So, I was using SQL Server but there is a need for me to change to SQLite. I had the following code that worked very fast for 600.000 rows (about a minute).     Dim SQLAdapter As New SqlDataAdapter     Dim dtKinoDraws As New DataTable     Dim SQLcmdBuilder As SqlCommandBuilder     'Emptying the ...