I am having an issue with MySQL query speed... Here is the query CakePHP is trying to perform:
SELECT `Review`.`id`, `Review`.`user_id`, `Review`.`book_id`, `Review`.`comments`, `Review`.`rating_plot`, `Review`.`rating_character_dev`, `Review`.`rating_style`, `Review`.`rating_pacing`, `Review`.`rating_overall`, `Review`.`published`, `Review`.`active`, `User`.`id`, `User`.`username`, `User`.`email`, `User`.`password`, `User`.`created`, `User`.`modified`, `User`.`first_name`, `User`.`last_name`, `User`.`birthday`, `User`.`sex`, `User`.`city`, `User`.`state`, `User`.`news`, `User`.`active`, `Book`.`id`, `Book`.`image`, `Book`.`title`, `Book`.`translators`, `Book`.`year`, `Book`.`year_suffix`, `Book`.`keywords`, `Book`.`isbn`, `Book`.`active` FROM `reviews` AS `Review` LEFT JOIN `users` AS `User` ON `Review`.`user_id` = `User`.`id` LEFT JOIN `books` AS `Book` ON `Review`.`book_id` = `Book`.`id` WHERE 1 = 1 When I throw that into phpMyAdmin, it gives me back my results in 0.0007 seconds. However, the time it takes Cake to generate the print_r results of that query on the page is 2.6624 seconds. I am trying to figure out what the hold up is. I was wondering if there is any type of specific error logs I could look at, or if anybody knows why this might be happening. - Anthony --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
