|
If they are large(ish) blobs you can use Filestream, which is a kind of a "best of both".
Although I only used it once as a prototype, never has a real use-case for it, so not sure what the downsides are.
|
|
|
|
|
|
I'd suspect it would be a pretty low performance file system - it's going to hammer the bandwidth as soon as files get big, or many users access them - and it is guaranteed to be slower than the equivalent local storage.
Storage is cheap at the moment - you can get internal 1TB SSD drive for under £100 - so I'd be tempted to set up a file server instead; relatively low processor requirements (compared to SQL) and full SMB shares from Windows or Linux boxes.
Or buy a NAS ready loaded.
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
You could store them as standard files but maintain a database that had the file location and information about the file. A Windows Service app could process file system change notifications to keep the database updated.
|
|
|
|
|
Yup, in multiple tastes.
You could use filestreams and access them like a FileSystem; needs a Windows share name and some configuration. See https://www.sqlshack.com/filestream-in-sql-server/[^] Easy to set up, and nice to have if you have a lot of blobs in your db, like images.
Alternative, you could look at the Dokan libraries; my article on it is outdated, but there was an open source interface to SQL Server. Dokan at the time was limited to roughly 50MB/s.
Last option might be FUSE, using Sql Server. See FUSE(file system in userspace) for Microsoft-SQL using C#[^].
Enjoy
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
This is the response I was looking for! Going to definitely check these out.
|
|
|
|
|
|
A question in Spanish. Now that is unusual in the Lounge.
/edit : tengas que preguntar ahi[^].
|
|
|
|
|
|
Two things:
1) This is an English language site, and we can only answer questions in that language. Use Google translate if your English isn't up to the task - it does a pretty good job of it!
Google Translate: 1) Este es un sitio de idioma inglés, y solo podemos responder preguntas en ese idioma. Use el traductor de Google si su inglés no está a la altura de la tarea, ¡lo hace muy bien!
2) This is the wrong place to post this, as it says at the top of the page. Posting programming questions here (in any language) will not get you much help, but may get you flamed. Post here instead:
Google Translate: 2) Este es el lugar equivocado para publicar esto, como dice en la parte superior de la página. Publicar preguntas de programación aquí (en cualquier idioma) no le dará mucha ayuda, pero puede incomodarlo. Publica aquí en su lugar:
Ask a question[^]
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
OriginalGriff wrote: will not get you much help, but may get you flamed. Google said: no le dará mucha ayuda, pero puede incomodarlo. I didn't know Google translator was that politically correct.
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
I have to assume it knows what it's doing.
It knows everything else - just like my wife, really.
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
In this case it translated it as:
it might bother you
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
OriginalGriff wrote: Use Google translate if your English isn't up to the task - it does a pretty good job of it!
Sure about it?
cheers,
Super
------------------------------------------
Too much of good is bad,mix some evil in it
|
|
|
|
|
Sure - Griff speaks welsh and has been translating it to English using Google all these years.
|
|
|
|
|
Rage wrote: Griff speaks welsh sheep FTFY
|
|
|
|
|
Sorry, I didn't know it was an English portal
|
|
|
|
|
Board meeting at mate's event? (5, 10)
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
|
Yay! Well done - I thought it would either go immediately, or stay forever ...
You are up tomorrow!
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Thanks! My very first one.
|
|
|
|
|
First of many, I hope ...
Good luck tomorrow!
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Certainly in the UK, the 80s was the decade of Thatcherism, greed, self and excess. And I struggle to remember much of any real value coming out of it.
But on 13th July 1985, (35 years ago today), something truly amazing happened:
Live Aid - Wikipedia[^]
This raised over £50 million for the starving in Ethiopia. A famine which saw over one million people die of starvation. What a disgrace. If that fact doesn't bring a tear to your eye, watch this video:
The Cars - Drive[^]
|
|
|
|
|
|
"We can't stop here - this is bat country" - Hunter S Thompson - RIP
|
|
|
|