你建议哪个数据库？ [英] Which Database do you suggest?

问题描述

你好朋友

我想知道你可以在一个程序中使用哪个数据库来存储图片，声音，文本，字符串和所有东西，但是不要给我提供SQL。它很好，但我需要快速安装并可以使用c＃。

我想存储大小为1到3 kb的500000张图片。

和30000 mp3和wave文件假设其中有1到3兆字节。

Hello friends
I want to know which database you may use in a program for storing pictures , sounds, texts, strings and everything, but don''t offer me SQL. Its good but i need something to be installed fast and can be used by c#.
and i want to store suppose 500000 pictures with size of 1 to 3 kb in it.
and 30000 mp3 and wave files suppose 1 to 3 mega byte in it.

推荐答案

根据Microsoft Research的研究，小于256K的对象最好存储在数据库中大于1M的对象最好存储在文件系统中。在256K和1M之间，读取：写入比率和对象覆盖率或替换率是重要因素。

http://research.microsoft.com/apps/pubs/default.aspx?id=64525 [ ^ ]



因此，我建议考虑混合方法，或将所有文件存储在文件系统上。您可以选择最熟悉的数据库。如果您的数据库大小不超过4G，MSSQL Server Express可能是一个不错的选择。



[UPD]如下所述，数据库大小限制为10G

According to Microsoft Research study, objects smaller than 256K are best stored in a database while objects larger than 1M are best stored in the filesystem. Between 256K and 1M, the read:write ratio and rate of object overwrite or replacement are important factors.
http://research.microsoft.com/apps/pubs/default.aspx?id=64525[^]

Thus, I would recommend to consider mixed approach, or store all files on a file system. You can choose database you are most familiar with. MSSQL Server Express could be a good choice, if your database size does not exceed 4G.

[UPD] as was correctly noted below, DB size limitation is 10G

让我们暂时不放弃SQL Server：有一个名为FILESTREAM的功能，可能正是您所需要的。并且SQL Server Express数据库大小限制不适用于FILESTREAM数据！

阅读这些：

- http://www.simple-talk.com/sql/learn-sql-server/an-introduction-to -sql-server-filestream / [ ^ ]

- 我如何：使用SQL文件流 [ ^ ]



但你不必坚持对于基于SQL的数据库，有一种方法称为 noSQL [ ^ ]。我建议你先看看这里： http://ravendb.net/docs/client-api/attachments [ ^ ]

Let us not abandon SQL Server for a second: there is a feature called FILESTREAM, that could be exactly what you need. And the SQL Server Express database size limitation does not apply to the FILESTREAM data!
Read these:
- http://www.simple-talk.com/sql/learn-sql-server/an-introduction-to-sql-server-filestream/[^]
- How Do I: Use SQL File Stream[^]

But you don''t have to stick to SQL based databases, there is an approach called noSQL[^]. I would suggest you look around here first: http://ravendb.net/docs/client-api/attachments[^]

这篇关于你建议哪个数据库？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！