|
|
Posted by tyler.style.post on 01/14/08 13:22
On Jan 13, 11:54 am, Gilles Ganault <nos...@nospam.com> wrote:
> Hello
>
> Out of curiosity, is there a way to avoid putting calls to MySQL in
> pages, and have PHP fetch data from a common pool, so that all
> connected users don't actually call MySQL directly, but simply read
> data from that common pool?
>
> Just an idea. I don't know if it makes any sense :-)
>
> Thanks.
My 2 bits: optimizing your queries so as to make the least number of
calls to your DB while pulling back the most compact amount of info
possible is definitely something to check for. When I was a computing
science TA, every so often I'd see the horror of people making a
database call inside of a loop :) Another one was making separate
pulls from several tables for related data, instead of using a join
and so pulling just once.
Tyler
Navigation:
[Reply to this message]
|