INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Oracle and Tiff Images

Oracle and Tiff Images

(OP)
Hello Friends.

We are re-designing our App and we have a critical question, what's the best way (in terms of performance) of using TIFF images (about 20K size) with Oracle.
Currently we have a Windows shared file server and we create the tiff images there under a huge directory structure (like /images/ddddmmyy/aa/bb/001, then /images/ddddmmyy/aa/bb/002, etc, etc). Our database is usually in LINUX version 10, 11 or 12.
We create about 200,000 images per day, keep them for 60 days and then remove that structure.
Our Web app (developed with .NET) reads those images just to display them on a Web Session (IE).

As you can see, what we are doing now works fine. But network sometimes is an issue and also it's hard to keep synchronization with our DR server, backups, etc.

Are we taking the correct approach? It would be better to have the images in CLOB or BLOBS for better performance? If so, can you provide me some suggestions on the best way to implement this?
As I mentioned, performance is the KEY FACTOR and the most important item to consider in this design.

Thanks,
Diego

RE: Oracle and Tiff Images

Diego,

My motto is, "One test is worth 100 expert opinions." So, you should be able to quickly build a small model for each of your technical alternatives and test the speed of the outcomes...both inputting and outputting. Don't waste time on these models with all of the "bells and whistles" of your UI...simply simulate each access alternative and test them.

...Then of course, post your results here so we can all benefit from your newly gained wisdom. smile

santaMufasa
(aka Dave of Sandy, Utah, USA)
“People may forget what you say, but they will never forget how you made them feel."

RE: Oracle and Tiff Images

Diego,

We have a similar problem in my place of work. It was originally decided (against my advice) to store files in the operating system, instead of the database.
This was supposed to be both easier and quicker but has in the end, turned out to be a liability.

When it comes to DR and/or point-in-time-recovery, I can restore the database using RMAN with no trouble, and hit a point in time.
However, there is no way of getting our images and other binary files consistently restored to a point in time.

The system administrator has recently admitted to me that he has no way of achieving such a recovery, and is therefore suggesting that files be put in the database.
It's only taken 3 years for the folks where I work to realise their mistake and do something about it.

If performance is acceptable, then for DR and recovery, the database is really the only way to go. As Santa rightly says, you have to test it first.

Regards

T

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close