-- advatage BLOB or file on file system --
From: REM <ilica.brnadic_at_zg.hinet.hr>
Date: Fri, 23 Jan 2004 21:24:49 +0100
Message-ID: <bus0np$enu$1_at_ls219.htnet.hr>
Date: Fri, 23 Jan 2004 21:24:49 +0100
Message-ID: <bus0np$enu$1_at_ls219.htnet.hr>
I have some problems. It's dilemma between BLOB, BFILE and takes care of file on file system. What it's advantage??
I import some PDF document in BLOB filed in my database. It's about 1000 documents on day.
My first question is: if I have a PDF on file system about 100 kb and if I import this in BLOB field in database. How much it's take more recourse.
How I can measure largeness of BLOB field or how I can measure spacious of the table?
-- thanks, ilica _________ "If A is a success in life, then A equals x plus y plus z. Work is x; y is play; and z is keeping your mouth shut." --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.515 / Virus Database: 313 - Release Date: 1.9.2003Received on Fri Jan 23 2004 - 21:24:49 CET