I have been scanning and storing images in the database for a couple of years now. We have eliminated the need for a file room. I currently have over 94,000 images stored in 26 R:base databases. These images range from photographs, scanned documents, and PDF files. The graphic files don't take up much more space storing the complete file in the database as to storing it in an individual file, but when it is in the database, you can control access to the file.
Troy Sosamon Denver, Co. ===== Original Message from [EMAIL PROTECTED] at 9/22/02 10:07 pm ><html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40";> > ><head> ><meta http-equiv=Content-Type content="text/html; charset=iso-8859-1"> ><meta name=ProgId content=Word.Document> ><meta name=Generator content="Microsoft Word 9"> ><meta name=Originator content="Microsoft Word 9"> ><link rel=File-List href="cid:[EMAIL PROTECTED]";> ><!--[if gte mso 9]><xml> > <o:OfficeDocumentSettings> > <o:DoNotRelyOnCSS/> > </o:OfficeDocumentSettings> ></xml><![endif]--><!--[if gte mso 9]><xml> > <w:WordDocument> > <w:View>Normal</w:View> > <w:Zoom>0</w:Zoom> > <w:DocumentKind>DocumentEmail</w:DocumentKind> > <w:EnvelopeVis/> > <w:DrawingGridHorizontalSpacing>2.5 pt</w:DrawingGridHorizontalSpacing> > <w:DrawingGridVerticalSpacing>5.1 pt</w:DrawingGridVerticalSpacing> > <w:DisplayHorizontalDrawingGridEvery>2</w:DisplayHorizontalDrawingGridEvery> > <w:DisplayVerticalDrawingGridEvery>2</w:DisplayVerticalDrawingGridEvery> > <w:Compatibility> > <w:SpaceForUL/> > <w:BalanceSingleByteDoubleByteWidth/> > <w:DoNotLeaveBackslashAlone/> > <w:ULTrailSpace/> > <w:DoNotExpandShiftReturn/> > <w:WW6BorderRules/> > <w:FootnoteLayoutLikeWW8/> > <w:ShapeLayoutLikeWW8/> > <w:AlignTablesRowByRow/> > <w:ForgetLastTabAlignment/> > <w:AutoSpaceLikeWord95/> > <w:DoNotUseHTMLParagraphAutoSpacing/> > <w:LayoutRawTableWidth/> > <w:LayoutTableRowsApart/> > </w:Compatibility> > </w:WordDocument> ></xml><![endif]--> ><style> ><!-- > /* Style Definitions */ >p.MsoNormal, li.MsoNormal, div.MsoNormal > {mso-style-parent:""; > margin:0in; > margin-bottom:.0001pt; > mso-pagination:widow-orphan; > mso-layout-grid-align:none; > punctuation-wrap:simple; > text-autospace:none; > font-size:12.0pt; > mso-bidi-font-size:10.0pt; > font-family:Arial; > mso-fareast-font-family:"Times New Roman";} >p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig > {margin:0in; > margin-bottom:.0001pt; > mso-pagination:widow-orphan; > mso-layout-grid-align:none; > punctuation-wrap:simple; > text-autospace:none; > font-size:12.0pt; > mso-bidi-font-size:10.0pt; > font-family:Arial; > mso-fareast-font-family:"Times New Roman";} >span.EmailStyle15 > {mso-style-type:personal-compose; > mso-ansi-font-size:10.0pt; > mso-ascii-font-family:Arial; > mso-hansi-font-family:Arial; > mso-bidi-font-family:Arial; > color:black;} >@page Section1 > {size:8.5in 11.0in; > margin:1.0in 1.0in 1.0in 1.5in; > mso-header-margin:.5in; > mso-footer-margin:.5in; > mso-paper-source:0;} >div.Section1 > {page:Section1;} >--> ></style> ></head> > ><body lang=EN-US style='tab-interval:.5in'> > ><div class=Section1> > ><p class=MsoNormal><span class=EmailStyle15><font size=2 color=black >face=Arial><span style='font-size:10.0pt'>I have an application that will >require access to app. 1000 photos (could grow to 4000-5000) currently stored >in JPEG format and app.400 Kb in size (each). The options are:<o:p></o:p></span></font></span></p> > ><p class=MsoNormal><span class=EmailStyle15><font size=2 color=black >face=Arial><span style='font-size:10.0pt'>- Store the pictures in a separate >directory and have a table in the database that stores the filename and path >and when the photo needs to be displayed, it simply “launches” the photo >using >a an external viewing software (such as photo >editor)<o:p></o:p></span></font></span></p> > ><p class=MsoNormal><span class=EmailStyle15><font size=2 color=black >face=Arial><span style='font-size:10.0pt'>- Load the picture as a blob, store >it in the database and display it from (or within) a >form.<o:p></o:p></span></font></span></p> > ><p class=MsoNormal><span class=EmailStyle15><font size=2 color=black >face=Arial><span style='font-size:10.0pt'>- Store the photos in a separate >database, attach it to the main database for access and display. <o:p></o:p></span></font></span></p> > ><p class=MsoNormal><span class=EmailStyle15><font size=2 color=black >face=Arial><span style='font-size:10.0pt'>What is the compression/overhead when >storing pictures as blobs? The database is currently app. 60 Mb and it would grow >considerably if the photos are stored in the database. What would be the >performance penalty?<o:p></o:p></span></font></span></p> > ><p class=MsoNormal><span class=EmailStyle15><font size=2 color=black >face=Arial><span style='font-size:10.0pt'>Any thought on these approaches or >any other that some one has successfully used would be greatly appreciated.<o:p></o:p></span></font></span></p> > ><p class=MsoNormal><span class=EmailStyle15><font size=2 color=black >face=Arial><span style='font-size:10.0pt'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p> > ><p class=MsoNormal><!--[if supportFields]><font color=black><span >style='color:black'><span style='mso-element:field-begin'></span><span >style="mso-spacerun: yes"> </span>AUTOTEXTLIST \s "E-mail >Signature" <span style='mso-element:field-separator'></span></span></font><![endif]--><font >size=2 color=black><span style='font-size:10.0pt;color:black'>Javier Valencia, >PE</span></font><font size=2 color=black><span style='font-size:10.0pt; >color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p> > ><p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size: >10.0pt;color:black'>President</span></font><font size=2 color=black><span >style='font-size:10.0pt;color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p> > ><p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size: >10.0pt;color:black'>Valencia Technology Group, L.L.C.</span></font><font >size=2 color=black><span style='font-size:10.0pt;color:black;mso-color-alt: >windowtext'><o:p></o:p></span></font></p> > ><p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size: >10.0pt;color:black'>14315 S. Twilight Ln., Suite #14</span></font><font size=2 >color=black><span style='font-size:10.0pt;color:black;mso-color-alt:windowtext'><o:p></o:p></s pan></font></p> > ><p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size: >10.0pt;color:black'>Olathe, KS<span style="mso-spacerun: yes"> ></span>66062-4571</span></font><font size=2 color=black><span style='font-size: >10.0pt;color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p> > ><p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size: >10.0pt;color:black'>(913)829-0888</span></font><font size=2 color=black><span >style='font-size:10.0pt;color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p> > ><p class=MsoNormal><font size=2 color=black face=Arial><span style='font-size: >10.0pt;color:black'>(913)649-2904 FAX</span></font><font size=2 color=black><span >style='font-size:10.0pt;color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p> > ><p class=MsoNormal><!--[if supportFields]><font color=black><span >style='color:black'><span >style='mso-element:field-end'></span></span></font><![endif]--><font >color=black><span style='color:black'><![if !supportEmptyParas]> <![endif]></span></font><font >color=black><span >style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p> > ></div> > ></body> > ></html> ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
