SQLTeam.com | Weblogs | Forums

How to quick delete and insert in database

sql2008r2

#1

Hello Friends,
i m asp.net developer .when insert or update operation performed through page page takes long time to execute query or you can say that it take long time to connect to sql .
how can easily performed operation like in this website


#2

Actually there's probably a ton of reasons for slow performance. Things to think about:

  1. Network (are there delays from the website to the server?)
  2. database Server (how busy is it?)
  3. What do your insert/update commands look like (post them here)
  4. What indexes are on the tables affected and are the statistics up to date?
  5. Is there regular index maintenance?

and many, many more...


#3

Are you talking about updating / inserting ONE SINGLE record, or lots of records (in a single batch)?