MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

No caching - or brutal performance - for repeat queries 4.1.8nt
Posted by: Ed Tilley
Date: December 20, 2004 12:14PM

I am running Win2000 Server, PHP, and mySQL 4.1.8 - local web users get great performance and remote internet users take up to 2 seconds to recieve a page generated by a repeated select query. Its as though the remote users select statements are not being cached.

I upgraded this database from 3.1.? to get the benefits of cache - so I am having grant and OLD_PASSWORD issues as well.

No too impressive really...

Thanks for any help.

Ed

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
No caching - or brutal performance - for repeat queries 4.1.8nt
3352
Ed Tilley
December 20, 2004 12:14PM
Re: No caching - or brutal performance - for repeat queries 4.1.8nt
2112
James Day
December 20, 2004 04:25PM
Re: No caching - or brutal performance - for repeat queries 4.1.8nt
2082
Ed Tilley
December 23, 2004 12:19PM
Re: No caching - or brutal performance - for repeat queries 4.1.8nt
2063
James Day
December 23, 2004 02:50PM
Re: No caching - or brutal performance - for repeat queries 4.1.8nt
2087
Ed Tilley
December 28, 2004 01:58AM
Re: No caching - or brutal performance - for repeat queries 4.1.8nt
2071
Andr Schršder
December 28, 2004 03:55PM
Re: No caching - or brutal performance - for repeat queries 4.1.8nt
2106
Peter Zaitsev
December 31, 2004 07:17PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.