From: Matthew M. <ma...@tu...> - 2003-05-01 12:45:47
|
Some of the reasons you are seeing all these extra SQL calls is that we received another warning a few months ago. That warning was that we were using far too much memory. So we reduced the dependance on the GLOBALS array. For example, the Cache used to store the information in the GLOBALS array so it would not have to be called more than once. This was removed to reduced the size of the GLOBALS array. Now the DB is called each time. So the question is, which is it? Do we want to depend upon the database each time to get our information? Or do you want offload some of the work by storing results in GLOBALS? Now that we know that classes eat up most of the memory, we may decide to place some data back and reduce DB calls. Matt |