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