Hi,
I do not recommend saving the image data in the DB:
1. The size of each DB Row increases dramatically.
Depending on the structure of your tables, query speed drops
as the rows are located further away on the disk (disk seek times)
2. For each image request, you have to involve some dynamic module
(php, perl, java,...) that generates the image and takes up DB resources.
On high frequented sites this can be a significant factor. Of course
you could also write a custom cache for that.
Regards,
Kai
query, sql
-Ursprungliche Nachricht-
Von: Alexis Antonakis [mailto:[EMAIL PROTECTED]]
Gesendet: Mittwoch, 9. Oktober 2002 13:57
An: list mysql
Betreff: 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)