Re: Storing blobs in database vs filesystem

From: Sandeep Dubey <dubey.sandeep_at_gmail.com>
Date: Fri, 29 Sep 2006 13:30:47 -0400
Message-ID: <bf2f74740609291030k53ff9187gdf65987745907971@mail.gmail.com>

My database is not on RAC, though we use data guard and linux cluster (heratbeat). The blobs are not updateable.

I am currently testing on the perfomance on reading/writing blob to database vs filesystem. To my suprise I found out to read about 6kb size of blob from database takes 200 ms, where as on file system it takes 550 ms - over 2.5 times more. I was expecting it to other wise. For writing database as well filesystem is taking 60 ms. Again I was expecting read to be faster than write.

Sandeep

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Sep 29 2006 - 12:30:47 CDT