On 3/15/07, Hugh Williams <hwilli...@openlinksw.com> wrote:
[Hugh] Can you please elaborate more on the need to a limit larger than 2GB as I am sure if we know more about what you are seeking to achieve a means can be devised for doing this all within virtuoso ? From the POV of the media server and the CMS+gallery: $ du -sh photos video mp3 4.5G photos 15G video 31G mp3 And I'm just a light user. Sharepoint does some icky stuff with spreading data that logically belong to one table around several tables to get past the 2GB limit, and since SQL Server doesn't have distributed keys, there goes the simple declarative method of consistency control. You're very much not supposed to muck around in the SQL Server database hsoting your sharepoint for reasons like this. Which kind of defeats the purpose of using a DBMS as your storage facility. I'll still look into the UDT that hosts large blobs outside the DB storage, but that does complicate ensuring data-metadata consistency. [Hugh] I presume photos, video and mp3 are folders containing individual files,
Yes.
in which are any of the physical files within these folders greater than 2GB,
Not currently, no. as that is the only point at which Virtuoso would have a problem storing
them ? If the files are less that 2GB in size then Virtuoso can efficiently manage such file stored in WebDAV storing each in a separate row of the same table. We do however accept that their is/may be a need for storing physical files greater than 2GB in size, thus Virtuoso Development agrees in principal that this limit should be increased, which shall be done sometime in the future.
Then I have probably explained myself poorly earlier -- SQL Server has a limitation of 2GB per column, not per row. That means for any given column, the total storage size combined for all rows cannot exceed 2GB. Which is already better than SQL Server 2000, which had 2 2GB limit per table. If Virtouso allows 2GB per row, I don't see any problems ahead; I'm not planning on storing video (as of yet), and a gallery will only host pictures that are 1G max, with 300K being typical. Emile
