It's been few days I'm following this conversation and I just wanted to
add something... It is true that both ways have their advantages and
disadvantages but do not forget that space is cheap now, data movement is
very easy but speed is costly. Improving one factor will affect the other
one negatively... so before taking a decision you should know which one to
sacrifice.Vahan -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Smith David G (Finance) Sent: Monday, April 25, 2005 4:04 PM To: [email protected] Subject: RE: [delphi-en] Re: Archive ideas wanted. We have a system that stores millions of document images as multi-page TIFFs in many directories. (Most of the image files are on optical storage, though that's "transparent to the user".) We use Oracle to store links to the files. This works pretty well; the directories really can't be browsed with Explorer, but why would you want to? This replaced a system that use BLOB fields in Informix to store single-page TIFFs. That worked fine too. I think there was a performance issue with BLOBs in Oracle, hence the change in architecture for the new system. David -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of dalewolver Sent: Friday, April 22, 2005 8:53 PM To: [email protected] Subject: [delphi-en] Re: Archive ideas wanted. As the originator of this thread I thought I'd throw in my two cents again. I use the technique of storing filenames in the database for 1 particularly good reason. The files must be accessible outside of the database application as well, plus as mentioned earlier if database gets bonkered you're access to the files is not impaired. In this application I store 250000 + growing small to large files (1.5k - 25 meg) and there in all kinds of different directories. The database application when creating the tables involved opens up theses files, extracts key information that can be used in other tables and queries to then provide a method of finding a file with particular parameters. The other application, related sortof, also contains a few hundred thousand files, but these ones are a small gif image and I keep them all in a single folder. The disk storage space is wasteful as the actual file size might be 1400 bytes and the disk storage allocated is close to twice that. As was also mentioned previously when you try to open up an explorer window on such a folder it will grind and grind for several minutes before giving you a listing. My issue was whether to use a blob to store the images somehow or some other massive streaming mechanism. The image folder is large, over 800 megs and grows by 2 to 5 megs a week. As for accessing the files, I've never really noticed a problem if I dont use explorer and just try to access a file directly via my application. I do hope to convert the massive image repository into a database then I'll be able to do some comparisons to access times. ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [EMAIL PROTECTED] Yahoo! Groups Links ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [EMAIL PROTECTED] ---------------------------------------------------------------------------- ---- Yahoo! Groups Links a.. To visit your group on the web, go to: http://groups.yahoo.com/group/delphi-en/ b.. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. [Non-text portions of this message have been removed] ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/delphi-en/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
