there are 8 database requests consuming 6 ms at all (only one of them
gets the list, the rest is about authentication, dynamic menus and
security. (the query joins the user table with a taglist) - displayed
data is only fetched out of the user table.
On 28 Jan., 11:11, Stéphane <stephane.er...@gmail.com> wrote:
> Does the "very first query" to retrieve users is selecting all needed (by
> your code) fields and relations ?
>
> If not, objects will "lazy-load" properties and relations.
> How many db requests are there ?
>
> Before Printing, Think about Your Environmental Responsibility!
> Avant d'Imprimer, Pensez à Votre Responsabilitée Environnementale!
>
> On Thu, Jan 28, 2010 at 11:08 AM, axel at <axel.zu...@gmail.com> wrote:
>
> > On 28 Jan., 06:49, Eno <symb...@gmail.com> wrote:
> > > On Wed, 27 Jan 2010, axel at wrote:
> > > > I didn't expect it to be faster than straight PHP, but it's about 35
> > > > times slower!!! do you have any constructive ideas for performance
> > > > tuning?
>
> > > People always make such a simplistic comparisons. There's lots you can
> > do,
> > > like optimize queries, use fumctional and template caching, etc. You also
> > > forget all the conveniences that using a framework brings you for free.
>
> > > You do actually have to learn a framework more fully before you can write
> > > code that makes such a comparison meaningful.
>
> > > --
> > I tried template caching, but it didnt't solve the problem as it is no
> > problem with the templateing. the following code takes 25 seconds too:
>
> > foreach ($event->getUserList() as $user) {
> > $test = $user->getLastname();
> > }
> > debugging toolbar shows that the query to get the result list only
> > takes 4ms so where the rest 25 seconds come from?
> > any ideas, this is really a huge problem and a need a solution since
> > our customzers won't accept such response times.
> > functional templateing wouldn't work here, since the result of
> > getUserList() chances almost every second.
>
> > maybe there is something wrong with my php/x-cache setup? any other
> > ideas or suggestions?
>
> > thx
>
> > --
> > 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<symfony-users%2bunsubscr...@googlegroups.com>
> > .
> > 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 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.
