On 22/07/11 18:11, Brian Leach wrote:
> Actually, Wol's right: the filestream option in SQL Server is just an entry
> point into the regular Windows file system, so in effect it's no different
> from using a type 19 directory.

I didn't know that :-)

So if you're using a filesystem that's naff at storing lots of files,
then SQL-Server will just drop you in it unnanounced. At least with U2,
you know you're storing up trouble and you need to do something about it.
> 
> Brian

Cheers,
Wol
> 
> **
>>
>> The filestream option in sql server is designed specifically for this
>> task.
> 
> But how does it manage things "under the hood"? That's the BIG problem
> with all relational databases, and one of the places U2 scores - it does
> NOT hide implementation detail behind a "you don't need to know this" flag.
> 
> It's easy to store all the documents in a type 1 file, and then manage
> the metadata elsewhere in U2.
> 
> Cheers,
> Wol
> _______________________________________________
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> 
> 
> _______________________________________________
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> 

_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Reply via email to