title: ASP.NET VB json into MySql
body: <p>can someone help me to make this Code much more efficene?</p>
  
  <p><div class="snippet" data-lang="js" data-hide="false">
  <div class="snippet-code">
  <pre class="snippet-code-js lang-js prettyprint-override"><code>        Dim SqlString = "INSERT test (id, fname, lname) VALUES (?,?,?)"
  
          Dim json As String = File.ReadAllText("c:\test.json")
          Dim array As JArray = JArray.Parse(json)
  
          Using Con As New MySqlConnection("Database=*;Server=*;User Id=*;Password=*")
              Using cmd = New MySqlCommand(SqlString, Con)
  
                  For Each item As JObject In array
                      Con.Open()
                      cmd.CommandType = CommandType.Text
                      cmd.Parameters.AddWithValue("id", item("id"))
                      cmd.Parameters.AddWithValue("fname", item("fname"))
                      cmd.Parameters.AddWithValue("lname", item("lname"))
                      cmd.ExecuteReader()
                      cmd.Parameters.Clear()
                      Con.Close()
                  Next
              End Using
  
              Response.Write("Done!")
  
          End Using</code></pre>
  </div>
  </div>
  </p>
  
  <p>Some Help would be great, i need to insert more then 100k entrys, every Day.</p>