You are here: Re: Sleepy database « PHP Programming Language « IT news, forums, messages
Re: Sleepy database

Posted by Jerry Stuckle on 03/08/06 04:55

frizzle wrote:
> Hi group,
>
> I have a site, which content is mostly based on what it finds in a
> mySQL database.
> All queries etc. are performed by PHP. Somehow, no matter what section
> of the
> site (still in test fase) i access, either small, with little DB info,
> or bif with big DB info,
> it seems that when i haven't accessed the page in at least 5 minutes,
> access it again
> the database is a lot slower the first load.
> As if it has to wake up, and get started again. When it has loaded the
> first time, and
> i refresh almost immediately speed is normal again ...
>
> How or why is this happening?
>
> Frizzle.
>

After you load it the first time, the info probably is in the cache -
and MySQL just pulls it from there.

Sounds like you need to look into why your first query runs so slowly.

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

 

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

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