You are here: Re: Reducing load for LAMP app? « PHP Programming Language « IT news, forums, messages
Re: Reducing load for LAMP app?

Posted by Richard on 01/05/08 01:58

"Richard" <root@localhost> wrote in message
news:477ee389$0$91156$dbd43001@news.euronet.nl...
>
> "Gilles Ganault" <nospam@nospam.com> wrote in message
> news:iqrrn3dmfhl974du205pnfm9onp53gsbn6@4ax.com...
>> Hello,
>>
>> I'm no LAMP expert, and a friend of mine is running a site which is
>> a
>> bit overloaded. Before upgrading, he'd like to make sure there's no
>> easy way to improve efficiency.
>>
>> A couple of things:
>> - MySQL : as much as possible, he keeps query results in RAM, but
>> apparently, each is session-specific, which means that results
>> can't
>> be shared with other users.
>> Is there something that can be done in that area, ie. keep the
>> maximum
>> amount of MySQL data in RAM, to avoid users (both logged-on and
>> guests) hitting the single MySQL server again and again?
>>
>> - His hoster says that Apache server is under significant load. At
>> this point, I don't have more details, but generally speaking, what
>> are the well-know ways to optimize PHP apps?
>>
>> Thank you.
>
> Why (or how) are the queries "session-specific"?
> No way to get rid of that?
>
> Richard.
>

Oh and BTW:

>> - MySQL : as much as possible, he keeps query results in RAM

It seems like a waste of memory to keep the results in RAM when you
know they will not be of any use to you afterwards. Immediately free
the mem for the next results sounds better to me.

Richard.

 

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

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