Use or not BLOB fields with SQL Server

Hot Topic

SELECT statement is showing unwanted display of data and is not passing data to a table.
similiar fields
Getting fox pro 6 data into an SQL 2000 database
VFP9 Multiple Detail Bands and Page Overflow
Timer Control not kicking in
Undoing the changes done in a form and exit
how to change field values?
create window
How can I use a stored procedure in my asp.net app
How to print a Table structure?

Visual FoxPro

Data design for my application - Comments welcome
All the sudden a batch of records (that were already in the table) are appended again?!?
Dot Net Examples with VFP
Database security
VFP 6.0 and MS Server 2003 Scheduler
Overload possible
Undoing the changes done in a form and exit
sending email from VFP through MS Outlook
Visual Foxpro tables locked by aspnet_wp.exe process
Biometrics on VFP

Use or not BLOB fields with SQL Server

Hi:

We are deciding which would be the better approach for managing a lot of files (PDF, JPG, DOC, DWG, ETC.). We are speaking about thousand of files and thousand of megabites.

As far as we are developing with VFP 9.0, we would be able to use BLOB fields. But we are not sure if it will be the best choice for us, taking in account, the amount and sizes of the files.

Could anyone help us

Regards,

Ana
Madrid, Spain
www.amby.net
www.PortalFox.com


Answer this question

Use or not BLOB fields with SQL Server

  • Pink

    Either BLOB, Memo binary or General field would be a good choice (I don't mean to use general fields as general fields on form but simply as a storage) IF you'd store them with data. Otherwise simply keeping the path and filenames would do. Managing Memo binary or general fields with SQL server's image datatype is a little tricky. I'd choose new BLOB datatype which is much easier to handle and even for short data directly might fill with a literal hex string as you could do with an SQL image type.
    All 3 have available memory and/or 2Gb limit.

  • David N.

    Thanks Craig, Thanks Cetin,

    Regards,

    Ana
    Madrid, Spain
    www.amby.net
    www.PortalFox.com


  • two_man_only

    No. I don't think it would. Besides having access to the database (for the anti-virus), the BLOB itself is encoded, not the original binary, so it wouldn't work.

    Same for VFP's BLOB field type.

  • RSVS2005

    None of the above Come on Craig, it's a suggestion not to store the file itself (as I noted) however in real world applications there are times you need to store it directly in database. If you're talking about thousands and maybe millions of files + SQL server it might be better to store them in the database than to store just path.

  • Captain Kenny

    If you use Blob fields and a file with a virus is put in that field, would and anti-virus software be able to see that file and clean it

  • Glaudiston

    None of the above. Store the image as a separate file. Have a field that stores the filename.



  • Use or not BLOB fields with SQL Server
Answer this question