Re: [PHP-DB] PreCaching Db into Variables Slows it down?!??

[M1tch]

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 [EMAIL PROTECTED] wrote in message
001801c25a09$99e9d840$[EMAIL PROTECTED]">news:001801c25a09$99e9d840$[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 [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Wednesday, September 11, 2002 8:36 PM
 Subject: [PHP-DB] PreCaching Db into Variables Slows it down?!??


  Grrr!
 
  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

Re: [PHP-DB] PreCaching Db into Variables Slows it down?!??

[Patrick Latour]

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 [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, September 11, 2002 8:36 PM
Subject: [PHP-DB] PreCaching Db into Variables Slows it down?!??


 Grrr!

 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