Hi Woh: > 2) Part of the reason for upgrading is that the application has taken a > HUGE hit in performance after we updated mysql connections to mysqli and > moved most of the php files above the web root folder.
The way files are included can be a significant performance issue. It's best to use full, true, paths when including files. One strategy I've used is having all scripts include one central config file via a relative path. Then in that script do this: define('PATH_BASE', realpath(dirname(__FILE__)); Then all other includes/requires in the application should do: require PATH_BASE . '/subdir/whatever/some_other_file.php' This removes the need to use the include_path and simplifies the operations PHP needs to do for caching file names and paths. Also, carefully consider the order of entries in the include_path setting. Put the directories in there in order of most used first, least used last. --Dan -- T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y data intensive web and database programming http://www.AnalysisAndSolutions.com/ 4015 7th Ave #4, Brooklyn NY 11232 v: 718-854-0335 _______________________________________________ New York PHP User Group Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk http://www.nyphp.org/show-participation