Hi all, I'm having a big problem with the admin generated for my models. Lets say I have photos, categories and slots and they're all many to many except photos don't have slots. So its like
Categories <--> Photos Categories <--> Slots When I first generated the admin, it was pretty fast. But now I have 65,000 photos and the category index page will no longer load. Both NginX and php-fpm will max out the execution time. Looking at SQL log, it looks like the category index page is selecting all photos. Why? I am guessing for hydrating the Doctrine_Collections for each category? So the admin is pretty useless now and I am really looking for a fix. How can I optimize? Perhaps turning hydration off? Here is my sql log (trimmed): 32 Query SET NAMES 'utf8' 32 Query SELECT COUNT(*) AS num_results FROM category m 32 Query SELECT m.id AS m__id, [...], m.slug AS m__slug FROM site m 32 Query SELECT m.id AS m__id, [...], m.updated_at AS m__updated_at FROM photo m Thanks in advance -- If you want to report a vulnerability issue on symfony, please send it to security at symfony-project.com You received this message because you are subscribed to the Google Groups "symfony users" 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/symfony-users?hl=en
