[rt-users] DBIx::SearchBuilder::Handle::Pg

[Kenneth Marshall]

Just an FYI. In preliminary testing, using the Handle::Oracle
definition for the DistinctQuery definition in Handle::Pg provides
quite a performance improvement. Here is the original line:

$$statementref = "SELECT DISTINCT main.* FROM $$statementref";

and the line from Handle::Oracle that should replace it:

$$statementref = "SELECT main.* FROM ( SELECT DISTINCT main.id FROM $$statementref ) distinctquery, $table main WHERE (main.id = distinctquery.id) ";

Ken Marshall