Tag Info

New answers tagged


Is the default setting for Sql Server comparable to "innodb_flush_log_at_trx_commit = 1" or to "innodb_flush_log_at_trx_commit = 2"? No. Assuming similar hardware, SQL Server should be just as slow as MySQL, since both would have to flush the commit for every row. Therefore there must be something else at play, very likely in the (not posted) C# code ...


On Button Click, I got to do something like this, as suggested by @MarkSinkinson. protected void btnSubmit_Click(object sender, EventArgs e) { SqlCommand cmd = new SqlCommand("Insert into CategoriesForMerchant (CategoryName) values (@CategoryName)", conn); cmd.Parameters.AddWithValue("@CategoryName", txtCategory.Text); conn.Open(); ...

Top 50 recent answers are included