[rt-users] DBIx::SearchBuilder::Handle::Pg -- again
Kenneth Marshall
ktm at rice.edu
Thu Feb 7 09:21:39 EST 2008
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 <ktm at rice.edu> -----
Date: Tue, 30 Jan 2007 10:23:52 -0600
From: Kenneth Marshall <ktm at rice.edu>
To: rt-users at lists.bestpractical.com
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: sales at bestpractical.com
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
----- End forwarded message -----
More information about the rt-users
mailing list