Well it looks like he tried using simple php and it worked great. Does the db query for user listing clearly "SELECT * FROM users" or such a thing stating it selects all fields ?
Before Printing, Think about Your Environmental Responsibility! Avant d'Imprimer, Pensez à Votre Responsabilitée Environnementale! On Thu, Jan 28, 2010 at 11:25 AM, Gareth McCumskey <[email protected]>wrote: > 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 <[email protected]> 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 [email protected]. > > To unsubscribe from this group, send email to > [email protected]<symfony-users%[email protected]> > . > > 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 [email protected]. > To unsubscribe from this group, send email to > [email protected]<symfony-users%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/symfony-users?hl=en. > > -- 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.
