On Thursday, March 3, 2016 at 2:28:58 PM UTC+1, Michal Petrucha wrote:
Merely based on your vague description, it seems to me that this is
one of the cases where you might be better off writing your SQL query
manually.
Narrowing results by `filter()` is very handy, in contrast to writing raw sql. I need to add GROUP BY clause only.
To be honest I'm waiting for official support for SQLAlchemy in Django, because Django ORM is very limited.
But after a while I realized that I should verify performance differences between DISTINCT and GROUP BY. Maybe today query planners are smart enough, so the "group by" trick can be abadoned.
The example of query is `select rel_id from some_table group by rel_id` (versus select distinct rel_id from some_table)
Marcin
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/2a3a9fdb-d899-42a3-971d-315504351f6d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment