Web服务的最佳数据库选择? [英] Best Database choice for a web service?

问题描述

我是一名正在读大二的CS学生.目前，我正在暑假实习，需要帮助.我的主管可以使用该网站，因为他正忙于自己的工作.所以我只做些琐碎的工作.

我有一个类库，其中包含我制作的Web服务的Web参考.
他告诉我，该Web服务将大量使用.

因此，我制作了Web服务，并需要它通过OS刷新该服务来保留其信息.所以我做了一个SQL服务器数据库.他说，他担心SQL Server数据库可能成为该程序的瓶颈.他说，尽力做到这一点，这样我们就不必使用数据库.他谈到了记忆.

所以我的问题是.如果我需要非常快的东西并且使用最少的内存以使服务器不会崩溃，那么这是最好的选择.

SQL Server数据库?或
嵌入式数据库引擎(DBF.NET 链接 [链接 [

I am a CS student who is becoming a sophomore. Currently I am working as a summer intern and I need help. My supervisor is ok for me using this website because he is busy with his own work. So I am only doing trivial work.

I have a class library that has a web refrence of my web service I made.
He told me that this web service is going to be used alot.

So I made the web service and I needed it to retain it''s information through OS refreshing the service. So I made an SQL server Database. He said he is worried that the SQL server Database might be the bottleneck of the program. He said, try to make it so we don''t have to use a database. And he said something about memory.

So my question here is. Which is the best choice to use if I need something to be very fast and use the least amount of memory so the server don''t crash.

SQL server Database? or
An embedded database engine (DBF.NET Link[^])? or
In-memory database (SQLite Link[^])

推荐答案

我能看到的唯一原因是瓶颈是如果您在其中存储大文件并拥有大量用户.我希望SQL Server胜过您提到的其他选项.如果您的SQL简单，则如果使用SQL Server并遇到问题，则可以稍后将数据库移至另一种类型，并查看其性能.

The only reason I can see for it to be a bottleneck is if you store big files in it and have a lot of users. I would expect SQL Server to outperform the other options you mention. If you keep your SQL simple, if you use SQL Server and have problems with it, you can move your DB to another type later and see how it performs.

这篇关于Web服务的最佳数据库选择?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！