Re: Caching Database Information

"Paul Higgins" <developer_paul_php@hotmail.com> wrote in message news:BAY22-F14FYHpZP5ui400025d71@hotmail.com... > > Can I cache too much and therefore negate the advantages of caching? Performance can be a very complicated subject. There is a good chance that the data is already cached. I don't know the details of how PHP, your hadrware and your operating system work, but it is very typical for data to be cached in memory by software and hardware. It is entirely possible that the most efficient solution is to simply have as much main memory as possible and let the hardware and software do what it already can do. Let's assume that the database data is cached by the database software and/or the operating system. Let's also assume that any cache that you create might cause virtual memory used by other software to be paged out. Then if that other memory needs to be paged back in then you easily coud be degrading performance by trying to improve it. You can't guess about perfomance. Effective optimization requires learning about the system and use of tools such as performance monitors.