Any known Issues with BLOB fields

[llmclaughlin]

Does anyone know of any known issues with using blob fields are performance issues. The reason I ask, I'm a programmer and I want to store images in blob field, but everytime I ask the dba to create a table with a blob field, she refuses to do it. Always says that there's to much over head and to many performance issues with blob fields. So, If someone knows how I can disprove this statement of her's, I'm all ears.

Thanks

Louie

 

[Thargy]

mac,

you've hit a standard issue problem. As a DBA I often get people telling me what tables they want etc., and often I don't grant their wishes, for very good reasons.

I suggest that you discuss this issue with your DBA, and take with you documentary evidence of the business requirement for what you're doing. Ask the DBA to provide a facility to deliver a function - don't ask for particular columns in tables.

If the DBA won't listen, escalate the issue. If the DBA will listen, let them use their best judgement to deliver what you need, not what you think you need.

Also, if they insist on stating performance reasons, then get the DBA to prove it. On a test instance, build the BLOBs, and based on measured query response times, the explain plan, tkprof results etc. get the DBA to prove it's unacceptably slow. If the DBA can't, then they'll just have to deliver what you've asked for.

N.B. this is not a technical issue, it's all about sound working practices and good DB design, with no time or energy available for egos and/or personal agendas.

Regards

Tharg

Grinding away at things Oracular