RE: Storing blobs in database vs filesystem

  • From: "Kevin Closson" <kevinc@xxxxxxxxxxxxx>
  • To: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 29 Sep 2006 10:42:26 -0700

>>>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.

You need to describe you test better for us to understand (and explain)
this performance delta. What are the mechanics for getting to
the filesystem data and what (in pseudo code) are the points in
which you are taking you measurements?

Very intersting work!

Other related posts: