You are here: Re: Difference between storing files on folder and in mysql db « PHP Programming Language « IT news, forums, messages
Re: Difference between storing files on folder and in mysql db

Posted by Jerry Stuckle on 01/09/08 20:31

NC wrote:
> On Jan 8, 8:12 pm, Jerry Stuckle <jstuck...@attglobal.net> wrote:
>> My point being that a network connection does not need to
>> be opened and close.
>
> Which network connection are we talking about -- the one between HTTP
> client and HTTP server or the one between MySQL client and MySQL
> server?
>

My misstatement. What I meant to say was that no additional network
connections need to be opened or closed (between the client and the
server).

>> And either way, if it's a commonly used image, the cache
>> (database or file system) can produce the image. In fact,
>> the database cache could be more efficient, as it doesn't
>> have to cache unrelated files, such as scripts.
>
> This is definitely true for content applications, where most recent
> items account for the lion's share of traffic, but it is generally
> false for social networking applications, where there are VERY few
> "commonly used" images, but rather, most of the content is used
> uncommonly -- my friends view my pictures, your friends view your
> pictures...
>
> Cheers,
> NC
>

In that case either way they won't be in the cache and will need to be
retrieved. However, it's still more likely it will be in the database
cache than the file system cache. There's a lot more going on in the
file system.


--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация