cayenne-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrus Adamchik (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CAY-2005) Improving generated DISTINCT performance on PostgreSQL
Date Tue, 21 Apr 2015 08:59:58 GMT
Andrus Adamchik created CAY-2005:
------------------------------------

             Summary: Improving generated DISTINCT performance on PostgreSQL
                 Key: CAY-2005
                 URL: https://issues.apache.org/jira/browse/CAY-2005
             Project: Cayenne
          Issue Type: Improvement
            Reporter: Andrus Adamchik
            Assignee: Andrus Adamchik


The problem is described here: http://markmail.org/message/j7alu33vfm7rjeba  Auto-generated
DISTINCT keyword when translating SelectQuery results in slowdown of PostgreSQL queries (won't
be surprised if this affects other DBs as well). Alternative PostgreSQL syntax "DISTINCT ON(id1,
id2, ..)" solves the issue.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message