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 The Natural Philosopher on 01/09/08 20:54

Jerry Stuckle wrote:
> 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.
>
>
...but its generally larger..in fact its probably true to say that all
ram NOT being used for programs,is used for file system cache in most
systems.


Any machine that isn't using every last ounce of RAM to cache
everything, is an overspecified machine IMHO ;-)

 

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

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