Home » RDBMS Server » Server Administration » Using of Blobs - possible performance issues
Using of Blobs - possible performance issues [message #185723] Thu, 03 August 2006 05:10 Go to next message
alexre2005
Messages: 7
Registered: March 2005
Location: Montreal,Canada
Junior Member
Hello,

We are considering using BLOBs in our Oracle 9i database( supposed to be migrated to 10g soon)

Here is the scenario

20 000 BLOB/year keeping during 5 years
100 inserts per day
200 reads per day
Maximum BLOB size is 150 Kb

What will be performance impact of using Blobs on INSERT/SELECT ?

Would it be better to separate BLOBs on the different tablespace ?

Thanks in advance

Alexander
Re: Using of Blobs - possible performance issues [message #185881 is a reply to message #185723] Fri, 04 August 2006 00:52 Go to previous message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
> What will be performance impact of using Blobs on INSERT/SELECT?

I suggest you write a small benchmarking routine and test it yourself. It would be great if you can post your results here as well.

> Would it be better to separate BLOBs on the different tablespace?

Why not - do it anyway.
Previous Topic: Reclaiming Diskspace in Linux from Oracle tablespace after truncate table
Next Topic: enabling archive logs
Goto Forum:
  


Current Time: Sun Dec 04 00:32:51 CST 2016

Total time taken to generate the page: 0.13620 seconds