SQL Express 与 SQL CE，延迟/滞后
规范称 SQL CE 作为“内存中进程”运行。这到底意味着什么？与 SQL Express 相比有什么区别？在这方面，SQL Express 是附加连接还是分离连接有关系吗？
我特别关心延迟/滞后，因为我的程序通常不是基于用户活动的，而是主要由算法和其他数据输入控制。考虑到这一点，我的印象是 SQL CE 可能比 SQL Server（& Express）更有优势。这有道理吗？
此外，如果任何其他（非 MS）数据库在该领域具有优势，那么最好也了解这些选项和信息。原因。
Specifications say SQL CE runs as an "in-memory-process". What does that really mean, and what is the difference of this compared to SQL Express? And does it matter if SQL Express is connected as attached or detached in that respect?
I'm specially concerned with latency/lag, as my program is not typically User-activity based, but mainly controlled by algorithms and other data-input. I have an impression that SQL CE may have an advantage over SQL Server (& Express) when considering this. Is there any truth to that?
Also if any other (non-MS) databases has advantages in this area, it would be nice to also know about those options & reasons.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
SQL Server Compact 是一组 DLL 文件（数据库引擎），由应用程序加载。 SQL Server (Express) 是一项 Windows 服务，必须通过网络接口访问。有关更多详细信息，请参阅此博客文章及其链接：http://erikej.blogspot.com/2011/01/comparison-of-sql-server-compact-4-and.html
SQL Server Compact is a set of DLL files (a database engine), loaded by your application. SQL Server (Express) is a Windows Service, and must be reahed via a network interface. For more details see this blog post and links therein: http://erikej.blogspot.com/2011/01/comparison-of-sql-server-compact-4-and.html