Hello There are lots of discussions in this regard and the suggestions are always to save your blob somewhere in your hard disk and just store the path.
In my case, each of my image is around 1MB but you know, I find it difficult to map the images stored in a particular machine, through a network using Delphi. But storing in the database solves most of the problems and the users can also easily load and retrieve them. But any suggestions from experts in this regard is welcome regards ----- Original Message ----- From: "Alexis Antonakis" <[EMAIL PROTECTED]> To: "list mysql" <[EMAIL PROTECTED]> Sent: Wednesday, October 09, 2002 8:57 PM Subject: RE: storing PDF files in mysql ????? > Hi, > > The thing I was wondering is whether there is any advantage in saving IMAGES > in a database? > > I have had a little play around with a 50k jpeg file and it appears that if > I save it in Blob format, then the filesize of the database increases by 50K > as well, and surely converting it from/to a database just add time to the > loading of a page, albeit it very minimal, but as I am designing a site > which will host huge numbers of photos, this will make a big difference. > > Any thoughts or advice on this topic will be most appreciated. > > Regards > Alexis > > -----Original Message----- > From: kayamboo [mailto:[EMAIL PROTECTED]] > Sent: 09 October 2002 01:20 > To: toby z > Cc: list mysql > Subject: Re: storing PDF files in mysql ????? > > > I think if you decide to store in the blob, > whatever it is, a pdf or jpeg or bmp, it is going to be in binary format. > While you need to display it back, just convert them back to whatever format > you like. > > Else there is always the choice of just storing the path in your database. > > By the way, which language you are using to write your applications. > If it is delphi, I can send you some sample code > > > regards > > ----- Original Message ----- > From: "toby z" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Wednesday, October 09, 2002 1:14 AM > Subject: Re: storing PDF files in mysql ????? > > > > thnx rich > > > > but u see the problem iz my clients want their text IN pdf format to be > > > > displayed with all these colors on the page in other words they want > > > > their sites layout to be maintained on the pages showing this pdf text > > > > as they are pretty concerned bout security > > > > > > so what do i do now ???? > > > > > > thnx a mill > > > > toby > > > > > > > > >From: "R.Dobson" <[EMAIL PROTECTED]> > > >To: toby gibbson <[EMAIL PROTECTED]> > > >CC: [EMAIL PROTECTED] > > >Subject: Re: storing PDF files in mysql ????? > > >Date: Tue, 08 Oct 2002 16:35:56 +0100 > > > > > > > > >hi, > > >2 ways to do this: > > > > > >a) don't store the file actually in the db but store the path to it. > > > > > >b)use the function LOAD_FILE(filename) to get the contents of a file as a > > >string value and store as a blob. > > > > > >decide which to use depending on how many pics you have > > > > > >cheers > > >Rich > > > > > >toby gibbson wrote: > > > > > >>ok guyz more trouble > > >> > > >>now im supposed to convert all the text (from ms word) to PDF and put > the > > >>pdf files in mysql db > > >> > > >>now i ve really got myslf stuck havent i > > >> > > >>can anyone plz hlp ???? > > >> > > >>thnx a million > > >> > > >>stuck az usual > > >> > > >>toby ..... > > >> > > >> > > >> > > >>_________________________________________________________________ > > >>Chat with friends online, try MSN Messenger: http://messenger.msn.com > > >> > > >> > > >>--------------------------------------------------------------------- > > >>Before posting, please check: > > >> http://www.mysql.com/manual.php (the manual) > > >> http://lists.mysql.com/ (the list archive) > > >> > > >>To request this thread, e-mail <[EMAIL PROTECTED]> > > >>To unsubscribe, e-mail > > >><[EMAIL PROTECTED]> > > >>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > >> > > >> > > > > > > > > >-- > > > > > >Richard Dobson > > >Database Administrator > > >MRC Bright Study > > >Clinical Pharmacolgy > > >St Bartholomew's and the Royal London > > >School of Medicine and Dentistry > > >Charterhouse Square > > >London EC1M 6BQ > > >Tel: 020-7882-5670 > > >Mob: 07711-522926 > > >Fax: 020-7882-5672 > > >[EMAIL PROTECTED] > > > > > > > > > > _________________________________________________________________ > > Send and receive Hotmail on your mobile device: http://mobile.msn.com > > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
