In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.
Dim da As New SqlDataAdapter("SELECT * FROM BSR", con) Dim con As New SqlConnection(My.Settings.BSROnSQLServer) Dim ds As New dsBSR Dim row As dsBSR.BSRRow ... Try If con.State = ConnectionState.Closed Then con.Open() End If 'Code to populate dataset is in this range ds.AcceptChanges() da.FillSchema(ds, SchemaType.Mapped, "BSR") Dim cb As New SqlCommandBuilder(da) da.InsertCommand = cb.GetInsertCommand da.UpdateCommand = cb.GetUpdateCommand MessageBox.Show(da.Update(ds, "BSR") & " records imported.", "Import results") Catch dbex As SqlException MessageBox.Show("Error: " & dbex.ToString) Finally con.Close() End Try ...
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.