Posted by Jerry Stuckle on 01/06/08 04:23

Gilles Ganault wrote:
> On Sat, 5 Jan 2008 02:55:24 +0100, "Richard" <root@localhost> wrote:
>> Why (or how) are the queries "session-specific"?
>> No way to get rid of that?
>
> I don't know what it means, really. I don't have enough experience
> with PHP and MySQL to know the details.
>
> Generally speaking, is there a way to share query results among all
> viewers using the site, and if yes, what's the right way to do this?
>
> Thanks for all the suggestions guys. It's very helpful.
>

Not from PHP, there isn't. Every user is considered independent. Just
like every program running in a system is considered independent.

Yes, you can share information between users - just like you can share
information between programs, i.e. shared memory. But it's not done by
default.

And as Richard indicated, the MySQL query cache may be more efficient.

However, right now it looks like me you are trying to optimize your
system - but haven't even identified where the source of your problem.

The FIRST thing you need to do is find out what's causing the high
resource utilization!

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

[Back to original message]