|
|
Posted by Jerry Stuckle on 01/05/08 02:41
Richard wrote:
> "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.
>
>
>
Maybe he's storing it in the $_SESSION variable - which isn't actually
written to memory - but to disk. And is very slow for large amounts of
data.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|