We have no way of automating the pagination API with composite indexes, as the paginator relies on `IN()` conditionals to function.
Since not all SQL RDBMSs support `IN()` conditionals with tuples, we cannot write an API that is portable and supports composite indexes. Marco Pivetta http://twitter.com/Ocramius http://ocramius.github.com/ On 5 April 2014 20:34, elemele <[email protected]> wrote: > Hi Marco, Benjamin, > Is there anu chance in the near future to resolve this problem: > > http://www.doctrine-project.org/jira/browse/DDC-2213?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel > > Marco - I can't change to unique single-field because this database is > working 24h and have billions of records powered by every seconds... its > a difficult operation. > > Thanks Guys - You area doing a great job! > Paul > > W dniu piątek, 25 października 2013 18:29:12 UTC+2 użytkownik Marco > Pivetta napisał: >> >> @Giorgio composite PKs are really hard to handle in ORM and generally >> data-access abstractions. >> >> There may be some denormalization, but I strongly suggest you to use an >> unique single-field scalar-valued identity and using an unique constraint >> over what was your previous PK instead. >> >> Marco Pivetta >> >> http://twitter.com/Ocramius >> >> http://ocramius.github.com/ >> >> >> On 25 October 2013 16:46, Giorgio Fellipe <[email protected]> wrote: >> >>> It really hurts... >>> At the moment the solution I got was remove my Secao relationship from >>> the primary key of my Subsecao, but it isn't a good solution for my data >>> model >>> >>> -- >>> 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/groups/opt_out. >>> >> >> -- > 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. > -- 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.
