| Using of Blobs - possible performance issues [message #185723] |
Thu, 03 August 2006 05:10  |
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  |
Frank Naude
Messages: 4580
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
