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

[Kenneth Marshall]

FYI,

This change has not been made to DBIx::SearchBuilder::Handle::Pg
for the definition of DistinctQuery. I just checked and you can
simply use the same definition of DistinctQuery for PostgreSQL
that you are using for Oracle in DBIx::SearchBuilder::Handle::Oracle.
This make a substantial performance improvement for RT with a
PostgreSQL backend database. It would be great if this change
could be rolled into the next update to DBIx::SearchBuilder.

Happy Holidays,
Ken

On Thu, Feb 07, 2008 at 08:21:39AM -0600, Kenneth Marshall wrote:
> 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 -----
> _______________________________________________
> 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
>