topic Re: Space taken by documents in db is smaller than real size? in Alfresco Archive

Space taken by documents in db is smaller than real size?

judyxiao — Thu, 04 May 2006 17:54:32 GMT

Hi, we are using Oracle database as the storage for document contents. I did some research on the space used in the database after uploading some documents (.pdf and .doc) through the interface. It seems to me that only 10% of space were taken in the database based on the original file size while th

Re: Space taken by documents in db is smaller than real size?

flafeer — Thu, 04 May 2006 18:12:07 GMT

Alfresco, like some other ECM systems, stores metadata in the database. And then it stores the content (and the full text indices) in the file system.

So what you are seeing in Oracle is not the content.

Hope this helps.

Firoze

Re: Space taken by documents in db is smaller than real size?

judyxiao — Fri, 05 May 2006 13:58:36 GMT

Thanks a lot Firoze for your helpful information. Then is there any documention to help us plan a good approach for monitoring the space usage of the file system? – Judy

Re: Space taken by documents in db is smaller than real size?

alexander — Wed, 10 May 2006 08:46:43 GMT

Content and indexes are stored in alf_data folder/directory.

Its size plus database size should be good indication of space usage.

Re: Space taken by documents in db is smaller than real size?

flafeer — Wed, 10 May 2006 14:53:39 GMT

Thanks a lot Firoze for your helpful information. Then is there any documention to help us plan a good approach for monitoring the space usage of the file system? – Judy

We keep our filestore on its own filesystem and we use the standard OS/filesystem level tools to monitor that. Of course, it's not necessary to have its own filesystem to do this.

Hope this helps,

Firoze

Re: Space taken by documents in db is smaller than real size?

judyxiao — Wed, 10 May 2006 18:09:01 GMT

Hi Alexander and Firoze, thanks both of you for your answers. I found those files as you indicated and appreciate that you shared your experience. Take care. – Judy

Re: Space taken by documents in db is smaller than real size?

paulhh — Thu, 11 May 2006 21:04:57 GMT

… of course, if you want to store the content as blobs in the DB, you can 🙂

Alfresco is very flexible - you can add or modify datastores to put it where you want how you want.

Cheers
Paul.