Hi!
Of course, it is MUCH better to store files. Either VFP or SQL server have certain hard-time things when working with BLOBS. Specially frustrating VFP's limitation to 2GB for FPT file (storing BLOBS in VFP memo field) or messing with workarounds to get/send data to SQL Server from VFP (see FAQ#7995). Anyway, to organize sequrity to hide certain group of BLOB files from users when using file system, you will require to have as many folders with sequrity settings as you have different sequrity groups.
>Which database is better at storing and retrieving Binary Large Object data.
>
>
>Security issues aside......
>Is it VFP or SQL Server.
>
>Is either of these a good technology for storing this type of data or are the BLOBS better dealt with as independent files in a folder.
>
>All comments gratefully received.
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.
