Did you run it through the dev environment? If so, the dev environment adds an additional processing overhead to the application as it keeps track of a number of different variables and symfony states to allow for debugging purposes. Also, try running the query itself on your databases command line client to help determine if perhaps the database itself is just really slow.
On Wed, Jan 27, 2010 at 8:58 PM, axel at <axel.zu...@gmail.com> wrote: > hello list, > > symfony seems to be extrem slow - compared to "native" php > a request with the following code takes ~26 seconds (count($event- >>getUserList()) == 5000) > > <?php foreach ($event->getUserList() as $user): ?> > <tr> > <td><?php echo $user->getFirstname(). " ". $user->getLastname > (); ?></td> > </tr> > <?php endforeach; ?> > > type calls time (ms) time (%) > Configuration 13 1932.20 7 > Factories 1 361.77 1 > Database (Doctrine) 8 0.06 0 > Action "event/listAction" 1 19.53 0 > View "Success" for "event/listAction" 1 25653.20 93 > Partial "event/_assets" 1 1.41 0 > Partial "event/_flashes" 1 5.31 0 > Component "address/menuItems" 1 68.60 0 > Partial "address/_menuItems" 1 3.23 0 > Component "address/loginState" 1 0.06 0 > Partial "address/_loginState" 1 2.06 0 > > the doctrine database query is ok > I don't think that the templating is the problem, (I tried to do the > output with echo $user->... from within the action what took as long > as if I used the template engine. for me it seems to be a doctrine > problem (foreach...?) > > is there a way to improove this poor results? > > -- > You received this message because you are subscribed to the Google Groups > "symfony users" group. > To post to this group, send email to symfony-us...@googlegroups.com. > To unsubscribe from this group, send email to > symfony-users+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/symfony-users?hl=en. > > -- Gareth McCumskey http://garethmccumskey.blogspot.com twitter: @garethmcc -- You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to symfony-us...@googlegroups.com. To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en.