Click here to Skip to main content
11,802,205 members (51,473 online)
Rate this: bad
Please Sign up or sign in to vote.
See more: database
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.
Posted 17-Jan-13 8:53am
Sergey Alexandrovich Kryukov at 17-Jan-13 15:03pm
Do you mean, not any relational databases based on SQL (language)? Or not, say, on MS SQL server? I'm asking because some relational database may provide SQL but be light weight enough for you, I don't know.
It really depends on further detail of your application and requirements. For example, ASP.NET vs some windows application may make considerable difference, deployment model, etc.
PIEBALDconsult at 17-Jan-13 16:03pm
I just use SQL Server (Express or CE for personal projects) for all that, but not in those quantities.
I have to work with a lot of different databases, but I wouldn't choose any other when I have a choice.
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

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.[^]

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
RedDK at 17-Jan-13 15:31pm
linkedserver makes a 4G database irrelevant but ... I concur MS SQL Server 2008 Express R2 with Advanced Services ... all the way!
PIEBALDconsult at 17-Jan-13 15:59pm
Isn't it 10GB now?
Vyacheslav Voronenko at 17-Jan-13 16:05pm
You are correct, R2 with Advanced Services has 10G limitation now.
Zoltán Zörgő at 18-Jan-13 3:24am
Not only AS, but all 2008 and 2012 express editions have 10GB per database file limit.
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

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:
- 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:[^]
Espen Harlinn at 17-Jan-13 16:39pm
Nice reply :-D
Zoltán Zörgő at 17-Jan-13 17:08pm

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 485
1 KrunalRohit 341
2 F-ES Sitecore 255
3 Afzaal Ahmad Zeeshan 220
4 CPallini 205
0 OriginalGriff 2,715
1 Maciej Los 1,900
2 KrunalRohit 1,797
3 CPallini 1,550
4 Richard MacCutchan 1,157

Advertise | Privacy | Mobile
Web03 | 2.8.151002.1 | Last Updated 17 Jan 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100