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

Kenneth Marshall ktm at rice.edu
Tue Jan 30 11:23:52 EST 2007


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



More information about the rt-users mailing list