Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2002091

Re: [PHP-DB] PreCaching Db into Variables Slows it down?!?? From: M1tch (m1tch101 <email protected>)
Date: 09/12/02

Cheers Patrick, I do keep them to a minimum, this is my 4th after the
session variables. And I intend it to be my last.

Andy

"Patrick Latour" <platour <email protected>> wrote in message
news:001801c25a09$99e9d840$0100a8c0 <email protected>
> Not yet a big specialist of PHP, but a rule that apply to nearly all
server
> side scripting languages, use global variables as less as you can.
>
> They simplify your programer's life, but on a server that is serving a lot
> of concurent sessions, it eats all the performances and ressources. It
does
> not explain your time problem, but it is my 2 cents before you place to
much
> stuff in global variables.
>
> Thanks and regards,
> Patrick
>
> ----- Original Message -----
> From: "M1tch" <m1tch101 <email protected>>
> To: <php-db <email protected>>
> Sent: Wednesday, September 11, 2002 8:36 PM
> Subject: [PHP-DB] PreCaching Db into Variables Slows it down?!??
>
>
> > Grrrrrrr!
> >
> > Just spent ages (well, 2hours) on a precaching system for my PHP code
that
> > didn't work out!
> > Hang on, I'll backtrack a bit...
> >
> > My website is using a php engine that picks at snippets of html from the
> > database, and builds them up to form the page.
> > A typical page may use 5 of these html snippets, each at maybe 5kb in
> size.
> >
> > I was sat thinking, looking at the debug-timer, and saw that the
templates
> > were one of the more time consuming aspects.
> > So I said, I know, I'll save the db a bit, and at the start of the
script,
> > read all the templates that I'll need into a global variable, and call
> them
> > from that.
> > Simple, 5 db calls put into 1, and templates taken out of memory.
> >
> > So why, oh why, has the time taken actually increased??? Does anyone
have
> > sufficient working knowledge of PHP to give me a hint at why this has
> > happened?
> >
> > Also, am I right in thinking that as the website hits increase, the db
> will
> > be put under increasing pressure, so it serves off better being called
> only
> > once instead of 5 times (Even though more data is taken out of it??).
> >
> > It's late, my eyes are blurring, and I'm annoyed. Very annoyed!
> >
> > Regards,
> > Andy
> >
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
> >
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.385 / Virus Database: 217 - Release Date: 9/4/2002
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php