Hi Marco i am a bit confused. if i understand you correctly. the doctrine pagintor will not work if i do this:
SELECT u,name, u,city from USERS The only way the pagintor will work is if i select all the properties of the class i.e: SELECT u from USERS if so, then how can i reduce my overhead. in my users class i have over 20 properties. i now have thousands of members in the database. i therefore need to find a way to reduce costs when i make a query on the database On Monday, January 12, 2015 at 8:59:59 PM UTC, Marco Pivetta wrote: > > Correct. In "SELECT f FROM Foo f", "Foo f" is the root of the selection. > > In order for the paginator to work correctly, all identifier fields from > the root of the selection must be part of the "SELECT" clause. > > Marco Pivetta > > http://twitter.com/Ocramius > > http://ocramius.github.com/ > > On 12 January 2015 at 21:56, Nima Sadjadi <[email protected] <javascript:> > > wrote: > >> By "root of selection" do you mean like >> SELECT u FROM.. >> instead of defining the coloumns? >> >> -- >> You received this message because you are subscribed to the Google Groups >> "doctrine-user" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> To post to this group, send email to [email protected] >> <javascript:>. >> Visit this group at http://groups.google.com/group/doctrine-user. >> For more options, visit https://groups.google.com/d/optout. >> > > -- You received this message because you are subscribed to the Google Groups "doctrine-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/doctrine-user. For more options, visit https://groups.google.com/d/optout.
