RE: Storing blobs in database vs filesystem

From: Kevin Closson <kevinc_at_polyserve.com>
Date: Fri, 29 Sep 2006 10:42:26 -0700
Message-ID: <5D2570CAFC98974F9B6A759D1C74BAD0E5B237@ex2.ms.polyserve.com>

 >>>

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

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

Received on Fri Sep 29 2006 - 12:42:26 CDT