Sergio, don't worry about the two queries. Even on MySQL it is OFTEN true that using SQL_CALC_FOUND_ROWS is slower than using two different queries. Don't really know why, but I suppose it has to do with internal optimization issues... Marco Pivetta @Ocramius <http://twitter.com/Ocramius> http://marco-pivetta.com
On 16 May 2011 19:14, Vincent Lechemin <vincent.leche...@gmail.com> wrote: > Just use the php function count on the results, it is O(1). > > -- > Vincent > > -- > 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 symfony-users@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 > -- 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 symfony-users@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
