|
|
Posted by Jerry Stuckle on 03/08/06 14:38
frizzle wrote:
> Toby Inkster wrote:
>
>>frizzle wrote:
>>
>>
>>>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.
>>
>>Is it a shared server with limited memory?
>>
>>If so, it may be that when your data hasn't been accessed in a while it is
>>swapped out of main memory onto disk to make way for other people's data;
>>then when requested again, it needs to be loaded back into memory.
>>
>>It's probably something along those lines.
>>
>>--
>>Toby A Inkster BSc (Hons) ARCS
>>Contact Me ~ http://tobyinkster.co.uk/contact
>
>
> Thanks all, i understand there isn't really anything i can do about it
> ... :(
> Except for switching DB-system (not really an option now) or optimize
> the PHP codes, which i already made as good as i'm capable of at the
> moment ...
>
> About the caching of data: if i first 'wake the server up' by accessing
> the news
> section of the site, and then go to links (both from DB) links is still
> a lot faster,
> as when visited immediately, though it's not in cache ...
> (First load really takes up to 10 secs, second up to 0.8 (still quite
> slow), can't be
> normal ... )
>
> The site is on a shared host.
>
> Anyway, thanks again!
>
Switching DB systems won't help. Every major DB implements some kind of
caching mechanism for performance reasons.
But it may not be the data which is cached, either. It might be the db
server has been swapped out, or any number of things. I really wouldn't
expect a different db server to act differently - because I don't think
it's a MySQL problem.
But since you're on a shared host, there's no way for you to
troubleshoot the problem. Have you tried talking to your hosting
company's support group? And if they can't help you, find a competent
hosting company.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|