Dear DBIx::SearchBuilder developers: Here is a re-send of a message that I posted in January of 2007 regarding a change in the DistinctQuery handling for PostgreSQL. Using the version from the Oracle definition is a big performance win. Would it be possible to include this change in the next update to DBIx::SearchBuilder?
Cheers, Ken ----- Forwarded message from Kenneth Marshall <[EMAIL PROTECTED]> ----- Date: Tue, 30 Jan 2007 10:23:52 -0600 From: Kenneth Marshall <[EMAIL PROTECTED]> To: [email protected] Subject: [rt-users] DBIx::SearchBuilder::Handle::Pg 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 _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com ----- End forwarded message ----- _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
