借助ADO.NET将记录插入Sql Server表的最快方法 [英] Fastest way to insert a record into Sql Server table with the help of ADO.NET

问题描述

您好，亲爱的朋友，我想知道在sql server数据库表中插入一条记录的最快方法，我知道该怎么做，但是我想知道在数据库中插入记录的最快方法.我是asp.net开发人员，现在我正在提高应用程序的运行速度，我们如何才能提高应用程序的性能，因此我想知道这一点.因此，如果有人能为您提供帮助，那将是我的荣幸.

感谢

Hello Dear Friends I want to know the fastest way to insert a single record in the sql server database table and i know how to do it but i want to know the fastest way to insert a record int the database. I am asp.net developer and now currently i am working speed of application that how can we boost our application''sperformance so that i want to know it. So if anybody can help e it will be the great pleasure for me.

Thanks

推荐答案

有很多可能影响数据库操作的参数.除非有人看到您正在使用的代码，否则很难告诉您是否应该/可以更改某些内容.仍然有一些提示:

1.检查表索引.高索引表在插入期间可能会有点慢，因为必须重新计算索引.
2.如何在应用程序中收集数据?我的意思是应该有效地从页面获取数据并将其发送到命令对象.
3.这也将取决于网络速度.如果应用程序服务器和数据库服务器的通信速度很慢，那么您在代码中就无能为力了.

如果您可以显示已经拥有的代码，则可以提供帮助的人. :)

There are various parameters that may affect the database operations. Unless someone sees the code you are using it is hard to tell if there something that should/can be changed. Still here are a few pointers:

1. Check the table indices. A heavily indexed table may be a bit slow during inserts since indices have to be re-calculated.
2. How is the data collected in the application? I mean getting the data from the page and sending to the command object should be done efficiently.
3. It will also depend on the network speeds. If the application server and database server communication is slow, there isn''t much you can do in the code.

If you can show the code you already have, someone can help with the possible remedies. :)

这篇关于借助ADO.NET将记录插入Sql Server表的最快方法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！