RE: DB_DataObject

> The secret history of DB_DataObjects :) > > I did quite a bit of profiling on dataobjects a while back - > as one of > the applications was getting very slow - the two big > performance hits where > a) debug() method calls > b) PEAR::getStaticProperty() calls on storing and retrieving database > connecitons Indeed, getstatic property calls represent half of the time spent in a script i have which is pretty database intensive. It still executes quite fast but other scripts are just too slow. Total Elapsed Time = 0.32 Total System Time = 0.01 Total User Time = 0.31 Real User System secs/ cumm %Time (excl/cumm) (excl/cumm) (excl/cumm) Calls call s/call Memory Usage Name ---------------------------------------------------------------------------- ---------- 35.5 0.11 0.11 0.11 0.11 0.00 0.00 1267 0.0001 0.0001 0 pear->getstaticproperty 6.5 0.01 0.01 0.02 0.02 0.00 0.00 4 0.0050 0.0050 0 function_exists 6.5 0.03 0.03 0.02 0.02 0.00 0.00 208 0.0001 0.0001 0 mysql_fetch_array 6.5 0.01 0.01 0.02 0.02 0.00 0.00 119 0.0002 0.0002 0 define 6.5 0.00 0.03 0.02 0.03 0.00 0.00 204 0.0001 0.0001 0 dataobjects_tbl_mytable->debug > in an effort to optimize it. > b) was solve by using global private variables > _DB_DATAOBJECT['RESULTS'] > etc. > ** most of this should be fixed in PHP5 with static object vars.. > > a) was a bit more complex - as every debugging call had to > make a call > to the config to find out if it needed to be run - just doing this > outside the calling operation didnt help, as it still had to > do alot of > function calls just to find out if it should debug.. > > In the end the best option I came up with was to initialize > DB_DataObject on load, to check for the production var and set the > global variable $_DB_DATAOBJECT_PRODUCTION > > now if you load the configuration after you have loaded > DB_DataObject - > then you will have to call DB_DataObject::staticInitialize().. Ok, i'll check that. > I've not really come up with a better solution for this yet.. > I guess it > could be the first thing that is checked on _connect = eg. is > $_DB_DATAOBJECT_PRODUCTION === false - if so load it from the config..