Long Raw and PERFORMANCE pitfalls with Oracle 7.3/4

From: Michael Shapiro <MShapiro_at_pop200.gsfc.nasa.gov>
Date: 16 Apr 1998 19:39:43 GMT
Message-ID: <6h5mpv$5j9@post.gsfc.nasa.gov>

Hello World!

I'm using Oracle 7.3.4 Long Raw to store MS Word 7 files (1-5MB). While I have just 200-300 files to store I don't have any performance problem neither on update nor on insert/delete. Response time is reasonable.

I wonder what may be future pitfalls when the Workload increase with time?
I'm experimenting with storing pointers to MS Word files rather than storing files themselves. Any experience with this?
I'm well aware about Oracle 8 new data type. Any experience with this?

Practical experience will be greatly appreciated.

TIA Received on Thu Apr 16 1998 - 14:39:43 CDT