I am not exactly sure, but i think there should not be such problems. Please check you database config to chk. You can give the sample of config here,
On Thu, Sep 6, 2012 at 10:35 PM, Zordon <[email protected]> wrote: > Hello everyone, after spending a lot of time trying to find out why cake > php executes queries very slow without success I came here to see if > someone can help me out. > > First this is the query from cakephp sql log and mysql processlist: > > SELECT *, COUNT(*) as hits FROM `hits_log` AS `HitsLog` LEFT JOIN > `countries` AS `Country` ON (`HitsLog`.`country_id` = `Country`.`countryID` > AND CAST(`HitsLog`.`country_id` as CHAR) = `Country`.`countryID`) LEFT JOIN > `regions` AS `Region` ON (`HitsLog`.`country_id` = `Region`.`countryID` AND > CAST(`HitsLog`.`region_id` as CHAR) = `Region`.`regionID` AND > CAST(`HitsLog`.`country_id` as CHAR) = `Region`.`countryID`) WHERE > `HitsLog`.`date` BETWEEN '2012-08-02 00:00:00' AND '2012-09-05 23:59:59' > GROUP BY `HitsLog`.`country_id` ORDER BY `hits` DESC; > > The problem is that it runs faster from the CLI about 0.88 to 1.3 seconds > no matter the difference of the dates, in cakephp it takes 20+seconds to > run if the dates difference is greater it will take a lot longer. > I also made a test with a simple mysqli class and it ran in seconds same > as CLI. > > Using cakephp 1.3 database driver set as "mysqli", "mysq" same results, > same user/pass in all tests. > > Some test were made first in the CLI then in the interface with cakephp to > avoid cache false positives. > > > Thanks in advance! > > -- > You received this message because you are subscribed to the Google Groups > "CakePHP" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > Visit this group at http://groups.google.com/group/cake-php?hl=en-US. > > > -- You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. Visit this group at http://groups.google.com/group/cake-php?hl=en-US.
