You are here: Re: Performance issues with frequently closing/opening mysql connections? « PHP Programming Language « IT news, forums, messages
Re: Performance issues with frequently closing/opening mysql connections?

Posted by Martien van Wanrooij on 12/02/06 19:10

"naixn" <naixn@won-fma.com> schreef in bericht
news:4571ccff$0$24440$79c14f64@nan-newsreader-05.noos.net...
> But there's another solution : you can, on the page that displays the
> dates,
> check the last modification time of the HTML cache file, and if it was
> modified before one day ago, you update the cache ( by doing the SQL
> request ),
> and then display the cache file ( since it has been updated... :D ).
Thanks this is a wonderful suggestion. My hosting provider gives me the
right to give writing access to certain folders and I guess that in rough
lines, caching means: writing data to a file on the server when a request is
made from a client?
> That would give you : one SQL request a day. Not so many, eh? :)
Enough info to study the topic seriously, one more question. You say, with
a smiley though, one SQL request a day so it could mean that the very first
visitor tonight at 0:00 generates a SQL request and that request writes
"something" to the caching file , when the second visitor shows up at 0:05,
he get his data from that recently update file? Sorry to ask it in such a
simplified way but with all due respect to all these wonderful cms'es I want
to understand the topic as thoroughly as possible.

Martien

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация