Hi Eric and Malcolm, On Sun, 2006-07-23 at 17:53 +1000, Malcolm Tredinnick wrote: > At the moment, you need to write some custom SQL to implement this. One > possible solution is here: > http://www.pointy-stick.com/blog/2006/06/14/custom-sql-django/
I'd like to suggest alternative SQL solution which performs better. With my example database Malcolm's query takes 214ms to execute, while my query does the same job in 5.8ms, which is 36 times faster. My solution is described here: http://groups.google.com/group/django-users/browse_thread/thread/f5021614b77993a4/5e64e2fa06255f90#5e64e2fa06255f90 -- Maciej Bliziński <[EMAIL PROTECTED]> http://automatthias.wordpress.com --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users -~----------~----~----~----~------~----~------~--~---
