List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:August 18 1999 6:48pm
Subject:Re: Storing GIF\'s in MySQL
View as plain text  
At 1:59 PM -0400 8/18/99, Urb LeJeune wrote:
>>I need to store GIF's in MySQL.
>
>	Why? increadable waste of space and performance destroyer.
>Why not just store a link?

I understand that you can get a degradation of performance if you do
a lot of inserts and deletes, unless you run OPTIMIZE TABLE regularly
to reduce fragmentation, but why would this affect performance otherwise.
I'm not sure I believe that the file system is faster at locating an
image file by searching through the directory than MySQL would be to
find an image record given an ID number.  I would expect the opposite.

As for wasting space, every file in a file system has wasted space,
unless it exactly fills up the last block allocated to it.  Why would
MySQL be worse than the file system?

-- 
Paul DuBois, paul@stripped
Thread
Storing GIF\'s in MySQLGeocrawler.com18 Aug
  • Storing GIF\'s in MySQLsinisa18 Aug
  • Re: Storing GIF\'s in MySQLMartin Ramsch18 Aug
  • Re: Storing GIF\'s in MySQLUrb LeJeune18 Aug
    • Re: Storing GIF\'s in MySQLPaul DuBois18 Aug
    • Re: Storing GIF\'s in MySQLScott Hess18 Aug
      • Re: Storing GIF\'s in MySQLUrb LeJeune18 Aug
        • Re: Storing GIF\'s in MySQLVivek Khera18 Aug
        • Re: Storing GIF\'s in MySQLPaul DuBois18 Aug
          • Re: Storing GIF\'s in MySQLOliver Artelt18 Aug
            • Re: Storing GIF\'s in MySQLMartin Ramsch18 Aug
              • Re: Storing GIF\'s in MySQLOliver Artelt19 Aug
                • Re: Storing GIF\'s in MySQLPaul DuBois19 Aug
              • Re: Storing GIF\'s in MySQLTracy R Reed21 Aug
                • Re: Storing GIF\'s in MySQLsinisa21 Aug
      • Re: Storing GIF\'s in MySQLPaul DuBois18 Aug
    • Re: Storing GIF\'s in MySQLScott Hess18 Aug
    • Re: Storing GIF\'s in MySQLRonald Beck19 Aug
      • Re: Storing GIF\'s in MySQLPaul DuBois19 Aug
        • Re: Storing GIF\'s in MySQLPeter J. Schoenster19 Aug
          • Re: Storing GIF\'s in MySQLMartin Ramsch19 Aug
            • Re: Storing GIF\'s in MySQLBenjamin Pflugmann20 Aug
          • importing text file with mysqlimportBob C. Ruddy22 Sep
            • Re: importing text file with mysqlimportBob Kline22 Sep
              • Re: importing text file with mysqlimportBob Kline22 Sep
              • Re: importing text file with mysqlimportBob C. Ruddy22 Sep
                • Re: importing text file with mysqlimportMartin Ramsch23 Sep
                  • Re: importing text file with mysqlimportPaul DuBois23 Sep
                    • Re: importing text file with mysqlimportMartin Ramsch23 Sep
                      • Re: importing text file with mysqlimportPaul DuBois23 Sep
                        • Re: importing text file with mysqlimportPaul DuBois23 Sep
    • Re: Storing GIF's in MySQLCarsten H. Pedersen19 Aug
      • Re: Storing GIF's in MySQLMartin Ramsch20 Aug
  • Re: Storing GIF\'s in MySQLDavid Biro [DaV3|D3]19 Aug
Re: Storing GIF\'s in MySQLFrank Piwarski19 Aug
  • Re: Storing GIF\'s in MySQLStephen Johnston19 Aug
    • Re: Storing GIF\'s in MySQLshane19 Aug
    • Re: Storing GIF\'s in MySQLThimble Smith19 Aug
    • Re: Storing GIF\'s in MySQLaaron abelard19 Aug
Re: Storing GIF\'s in MySQLRaymond Gubala19 Aug
RE: Storing GIF's in MySQLHoward Lin20 Aug
  • Re: Storing GIF's in MySQLBenjamin Pflugmann20 Aug
  • RE: Storing GIF's in MySQLVivek Khera20 Aug
    • Re: Storing GIF's in MySQLMartin Ramsch20 Aug
  • Failing to unsubscribeJoel Palenychka22 Aug
  • Modifying SET columnsAndrian Pervazov22 Aug
    • Re: Modifying SET columnsPaul DuBois23 Aug
  • Re: Modifying SET columnsAndrian Pervazov23 Aug
    • Re: Modifying SET columnsBenjamin Pflugmann23 Aug
      • Re: Modifying SET columnsPaul DuBois23 Aug
  • Re: Modifying SET columnsGerald Clark23 Aug
  • Odd increments with mysql and php3.Matt Duggan24 Aug
    • Odd increments with mysql and php3.sinisa25 Aug
Re: Modifying SET columnsDave Kaufman23 Aug
  • Re: Modifying SET columnsPaul DuBois23 Aug