blocks|key|23663|text|设置adonet.batch_size可以改善这种情况。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|23664|为此，您必须|23665|NH+configuration中的|23666|set+adonet.batch_size|unordered-list-item|23667|23668|示例：|23669|++++m_sessionFactory+=+Fluently
+++++++++.Configure()
+++++++++.Database(MsSqlConfiguration
+++++++++++++.MsSql2005
+++++++++++++.ConnectionString(c+=>+c.FromConnectionStringWithKey("testme"))
+++++++++++++)
+++++++++.Mappings(m+=>+m.FluentMappings
+++++++++++++.AddFromAssemblyOf<TestImpl>())
+++++++++.ExposeConfiguration(config+=>
+++++++++{
+++++++++++++config.SetProperty("adonet.batch_size",+"1");
+++++++++++++m_configuration+=+config;
+++++++++})
+++++++++.BuildSessionFactory();|code-block|syntax|javascript|23670|23671|在保存之前设置会话的批处理大小|23672|23673|using+(ISession+session+=+m_nhibernateSessionFactory.GetSession())+using+(var+tx+=+session.BeginTransaction())+{+session.SetBatchSize(1000)；foreach+(服务器中的var服务器){session.SaveOrUpdate(服务器)；}+tx.Commit()；}|23674|entityMap^0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Z|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|10|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|11|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|12|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|13|8|@]|9|@]|A|$]]|$1|L|3|M|5|N|7|14|8|@]|9|@]|A|$O|P]]|$1|Q|3|-4|5|6|7|15|8|@]|9|@]|A|$]]|$1|R|3|S|5|H|7|16|8|@]|9|@]|A|$]]|$1|T|3|-4|5|6|7|17|8|@]|9|@]|A|$]]|$1|U|3|V|5|6|7|18|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|19|8|@]|9|@]|A|$]]]|X|$]]

setting adonet.batch_size could improve the situation.

For that you have to 

<ul>
<li>set adonet.batch_size in the NH configuration</li>
</ul>

Example:

<pre><code> m_sessionFactory = Fluently
 .Configure()
 .Database(MsSqlConfiguration
 .MsSql2005
 .ConnectionString(c =&gt; c.FromConnectionStringWithKey("testme"))
 )
 .Mappings(m =&gt; m.FluentMappings
 .AddFromAssemblyOf&lt;TestImpl&gt;())
 .ExposeConfiguration(config =&gt;
 {
 config.SetProperty("adonet.batch_size", "1");
 m_configuration = config;
 })
 .BuildSessionFactory();
</code></pre>

<ul>
<li>set the batch size on the session just before the save

<pre><code>using (ISession session = m_nhibernateSessionFactory.GetSession())
using (var tx = session.BeginTransaction())
{ 
 session.SetBatchSize(1000); 
 foreach (var server in serverz)
 {
 session.SaveOrUpdate(server);
 }
 tx.Commit();
}
</code></pre></li>
</ul>

blocks|key|23702|text|DataSet？不是的。大容量插入？是。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|23703|如果您要插入这么多记录，并且插入非常简单，那么您应该考虑进行批量插入和提取ORM。|23704|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

DataSet? No.
Bulk Insert? Yes.

If you are inserting that many records and the inserts are pretty simplistic, you should look at doing Bulk Inserts and pulling out the ORM.

blocks|key|921642|text|插入记录的最快方法是生成文本文件并使用LOAD+file语法。大多数数据库在将数据文件导入数据库时都有非常快的实现。对于MySQL，请参见下面的内容：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|921643|http://dev.mysql.com/doc/refman/5.1/en/load-data.html|offset|length|921644|对于其他数据库，请参阅相应的手册。如果您要频繁插入一百万条记录或数千条记录，这将非常有用。否则，最好的方法就是创建一个包含数千个插入的大型SQL，并直接在数据库连接上执行它，跳过ORM及其相关的验证。|921645|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|1H|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@]|9|@$D|Q|E|R|1|S]]|A|$]]|$1|F|3|G|5|6|7|T|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|U|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|C]]]]

The fastest way to insert records is to generate a text file and use LOAD FILE syntax. Most databases have remarkably fast implementations to importing data files into the databases. For MySQL, see below:

<a href="http://dev.mysql.com/doc/refman/5.1/en/load-data.html" rel="nofollow noreferrer">http://dev.mysql.com/doc/refman/5.1/en/load-data.html</a>

For other databases, refer to appropriate manual. This is useful if you are inserting a million records, or thousands of records frequently. Otherwise, the best you can do is create a big SQL with the 1000s of inserts and execute that on your database connection directly, skipping ORMs and their related validations.

blocks|key|921671|text|我认为你有很多选择，这取决于你的情况。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|921672|如果你可以使用NHibernate+2.1Alpha，你可以尝试使用新的可用的可执行HQL。|921673|http://nhibernate.info/blog/2009/05/05/nh2-1-executable-hql.html|offset|length|921674|托比亚斯的答案也同样适用。只需设置批处理大小就可以显著提高性能。|921675|如果你想用ADO.Net弄脏你的手..。|921676|通过使用Sql大容量复制，可以在Sql+Server中执行大容量插入。|921677|下面是一个这样的例子：http://dotnetslackers.com/articles/ado_net/SqlBulkCopy_in_ADO_NET_2_0.aspx|921678|在我看来，您似乎是在基于数据库中的另一个实体创建一个新的实体。对我来说，这似乎是使用存储过程的理想场景。|921679|entityMap|0|LINK|mutability|MUTABLE|url|1|http://dotnetslackers.com/articles/ado_net/SqlBulkCopy_in_ADO_NET_2_0.aspx^0|0|0|0|1S|0|0|0|0|0|B|22|1|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|11|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|12|8|@]|9|@$F|13|G|14|1|15]]|A|$]]|$1|H|3|I|5|6|7|16|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|17|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|18|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|19|8|@]|9|@$F|1A|G|1B|1|1C]]|A|$]]|$1|P|3|Q|5|6|7|1D|8|@]|9|@]|A|$]]|$1|R|3|-4|5|6|7|1E|8|@]|9|@]|A|$]]]|S|$T|$5|U|V|W|A|$X|E]]|Y|$5|U|V|W|A|$X|Z]]]]

I think you have a number of options depending on your situation.

If you can use NHibernate 2.1 alphas you can try to use the new Executable HQL that's available.

<a href="http://nhibernate.info/blog/2009/05/05/nh2-1-executable-hql.html" rel="nofollow noreferrer">http://nhibernate.info/blog/2009/05/05/nh2-1-executable-hql.html</a>

Tobias's answer will work as well. Just setting the batch size will increase the performance respectably.

If you want to dirty your hands with ADO.Net...

Doing Bulk Inserts in Sql Server is possible through the use of Sql Bulk Copy.

An example of that is here: <a href="http://dotnetslackers.com/articles/ado_net/SqlBulkCopy_in_ADO_NET_2_0.aspx" rel="nofollow noreferrer">http://dotnetslackers.com/articles/ado_net/SqlBulkCopy_in_ADO_NET_2_0.aspx</a>

To me it seems like you're creating a new entity based off of another entity in the database. To me that seems like an ideal scenario to use a stored procedure.

blocks|key|24366|text|我相信这就是你要找的：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|24367|Bulk+Data+Operations+With+NHibernate's+Stateless+Sessions|offset|length|24368|本质上不是打开一个ISession，而是打开一个IStatelessSession，然后在hibernate.cfg.xml中设置：|24369|+<property+name="adonet.batch_size">100</property>|code-block|syntax|javascript|24370|entityMap|0|LINK|mutability|MUTABLE|url|http://nhibernate.info/blog/2008/10/30/bulk-data-operations-with-nhibernate-s-stateless-sessions.html^0|0|0|1L|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@$D|W|E|X|1|Y]]|A|$]]|$1|F|3|G|5|6|7|Z|8|@]|9|@]|A|$]]|$1|H|3|I|5|J|7|10|8|@]|9|@]|A|$K|L]]|$1|M|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|N|$O|$5|P|Q|R|A|$S|T]]]]

I believe this is what you are looking for:

<a href="http://nhibernate.info/blog/2008/10/30/bulk-data-operations-with-nhibernate-s-stateless-sessions.html" rel="nofollow noreferrer">Bulk Data Operations With NHibernate's Stateless Sessions</a>

Essentially instead of opening an ISession, you open an IStatelessSession, and in your hibernate.cfg.xml you can set:

<pre><code> &lt;property name="adonet.batch_size"&gt;100&lt;/property&gt;
</code></pre>

I'm using NHibernate currently. I have a situation where I need to save a bunch of records to the database like this:

<pre><code>var relatedTopics = GetRelatedTopics(topic);
foreach (var relatedTopic in relatedTopics /* could be anywhere from 10 - 1000+ */)
{
 var newRelatedTopic = new RelatedTopic { RelatedTopicUrl = relatedTopic, TopicUrl = topic.Name };
 _repository.Save(newRelatedTopic);
}
</code></pre>

When there are a ton of records to save this is obviously very taxing having to hit the database that many times. What's a better approach? Is there some sort of batch update I can do? Am I better off using a DataSet?

Thanks

Saving 1000+ records to the database at a time

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我目前使用的是NHibernate。在这种情况下，我需要将一堆记录保存到数据库中，如下所示：var relatedTopics = GetRelatedTopics(topic);foreach (var relatedTopic in relatedTopics /* could be anywhere from 1...

问一次将1000+记录保存到数据库
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问一次将1000+记录保存到数据库EN