Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Store as Blob or in FileSystem?
Message
From
19/11/2017 22:49:40
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Store as Blob or in FileSystem?
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
SAMBA Server
Database:
MySQL
Application:
Desktop
Miscellaneous
Thread ID:
01655704
Message ID:
01655704
Views:
58
Hi Guys,

I came across a prospective client who needs to have their documents managed, i.e., stored centrally, accessed quickly via a search facility, viewed or downloaded or even printed.

The documents are of various types - tax returns, corporate papers, business permits etc - of 100 stores.

I am aware that this query has been asked before, but in your experiences, which is the way to go - store the documents (scanned as Jpegs or PDFs usually) - in BLOB columns? Or merely let them reside in the computer's File System?

In my readings, it seems these are two opposing views.

Your suggestions please!

Thanks.
Next
Reply
Map
View

Click here to load this message in the networking platform