From 0732d32f508045da40fe9df607b9ef20ce2d198f Mon Sep 17 00:00:00 2001 From: xaver <xaver@ispconfig3> Date: Tue, 06 Mar 2012 10:03:23 -0500 Subject: [PATCH] join fix - disappered in commit + Switch traffic joins, because its faster - Tested in a productive system (MySQL 5.1) as query few tausend domains 1-3 sec for Webtraffic sort, faster SQL = faster and MySQL 5.5 is much faster with joins (standard is not sorted with slow traffic querys) -> slowest part is coping the tables into temp -> more tweeks on cache... -> faster by heavy use --- CODING_NOTES.php.txt | 2 ++ 1 files changed, 2 insertions(+), 0 deletions(-) diff --git a/CODING_NOTES.php.txt b/CODING_NOTES.php.txt index 9b7ae8e..b761abb 100644 --- a/CODING_NOTES.php.txt +++ b/CODING_NOTES.php.txt @@ -6,6 +6,8 @@ * every php file starts and end with <?php ?> no spaces before or after * error_reporting(E_ALL|E_STRICT) , yep php5 * Magic quotes is gone in php6, get used to it now. config = magic_quotes_gpc() Everything must be quoted +* Don't use ereg,split and other old function -> gone in php 5.4 or 6 (different information on php.net) http://www.php.net/manual/en/migration53.deprecated.php +* Don't use shorttags. A Shorttag is <? and that is confusing with <?xml -> always <?php please mark any section that need review or work on with // TODO -- Gitblit v1.9.1