Well, if you have other varchar fields in your table, then it probably
wouldn't have any impact on performance. But since BLOBS and TEXT are
considered varchar, the table no longer is a fixed width. It is my
understanding that MySQL can locate specific records faster (even with
indexes) in tables with fixed widths (i.e., no variable-length columns).
----- Original Message -----
From: "WCBaker" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Friday, February 23, 2001 11:07 AM
Subject: generic question re. image blobs in dbs
> Hi!
>
> There is a consensus that blobs containing image files like .jpgs, .gifs,
> etc. might better be stored just as links in the database, with the
actual
> files in a directory pointed to by the database links. Forgive my
> ignorance, but can someone explain a few of the more obvious reasons why
> this makes a difference? For example, if I avoid SELECT * when referring
> to a table with blobs it seems to be pretty fast. . . So I'd only refer
> to the heavyweight column when absolutely necessary. Does it take a lot
> longer to pull out the blob than it would to load the file contents into a
> browser?
>
> Thanks for any information you can impart!
>
> Cheers!
>
> -Warren
>
>
> ---------------------------------------------------------------------
> 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