Martin, Actually, most times it's MUCH faster to store the file name in the database and have the "application" retreive it from there. In my experimentation (admittedly a long time ago), it was an order of magnitude faster to store the images on the file system. I have not, however tested the BFILE type. The "relatively new" BFILE type in Oracle stores the file in the file system, but you can retrieve the contents via SQL. That may be faster than the old store it in a long method. However, storing it in the file system and having the application retreive the data from the file system used to be orders of magnitude faster. SQL*Net may have gotten faster, but the raw file system is probably still faster...
The application I supported now has over 40 million TIFF images at one site, 20 million at another, etc. So, we were VERY concerned about speed of retrieval. If anyone has updated benchmarks contrary to this, I'd love to see them. Regards, Jeff > -----Original Message----- > From: Martin Wong [mailto:[EMAIL PROTECTED]] > Sent: Thursday, June 27, 2002 2:56 AM > To: [EMAIL PROTECTED] > Subject: using oracle BLOB from perl? > > > Dear sir, > > I'm an web developer using oracle 8i database and perl as my web > programming. We develop a GIS application. as long as we can do > we just save picture's name to link to a GIF format picture. how > could we change this way using BLOB in case to increase our > speed. Please give us a simple sample to show the BLOB data type > content into our web page using perl. I'm waiting for your reply > soon. thank you. >
