SubSonic 3.0.0.4 与 2.1 相比有何重大性能改进？
是否值得升级到 SubSonic 2.1 以上的最新稳定版本？我们遇到了一些性能和可扩展性问题，这些问题很快变得不可接受，而且我还没有真正找到任何明确的内容来指出任何真正有帮助的内容。
我想看看是否可以利用一些测试模型，但我想我会问。
谢谢。
Is it worth upgrading to the latest stable version of SubSonic over 2.1? We are running into some performance and scalability issues that are quickly becoming unacceptable and I haven't really been able to find anything definitive that points to anything that could really help.
I'm going to see if I can harness out some testing models but thought I'd ask.
thanks.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
不知道这是否有帮助，但我发现写入性能的一个主要因素取决于表中是否存在默认值。 Subsonic 2.1 在创建新记录时对数据库中的每个值执行 SELECT，这确实会减慢速度。如果常量，编写一个补丁来缓存这些内容并不会太难（显然您不想缓存“SELECT GetDate()”，但“SELECT 1”不会产生太多惊喜）。
不确定 3.x 在这里做什么；我还没去过那儿。
如果写入性能不是问题，这可能没有用，但在这种情况下，更多信息会更好。
Don't know if this will help, but I have found a major factor in write performance depends on the presence of default values in tables. Subsonic 2.1 performs a SELECT against the database for each value when creating a new record, and these can really slow things down. It wouldn't be too hard to write a patch to cache these if constant (clearly you don't want to cache 'SELECT GetDate()', but 'SELECT 1' isn't going to yield too many surprises).
Not sure what 3.x does here; I haven't gone there yet.
This may be of no use if write performance is not the issue, but in that case more info would be good.