[rt-users] Changing database connection options?

[Kevin Falcone]

On Tue, Dec 14, 2010 at 02:18:13PM +0100, hubert depesz lubaczewski wrote:
> On Mon, Dec 13, 2010 at 10:57:03AM -0500, Kevin Falcone wrote:
> > On Sat, Dec 11, 2010 at 11:40:17PM +0100, hubert depesz lubaczewski wrote:
> > > Hi,
> > > another question: is there any way to change database connections
> > > options from config?
> > > I.e. I want to change what's being passed as 4th argument to
> > > DBI->connect().
> > 
> > You'd need to patch DBIx::SearchBuilder to provide an option for RT to
> > use and then patch RT to use that option.
> 
> Hmm. This looks like a very complicated task. Wouldn't it be possible,
> to just call:

I'm delineating the right way to do it.

> $dbh->{'pg_server_prepare'} = 0;
> from rt?
> 
> Reason - server side prepared statements are rarely useful, usually they
> do not speed things up, and they break some setups.
> 
> Of course I can modify my own copy of rt, but patching it again and
> again after every upgrade seems to be suboptimal.

I'm leery to make a change like that for RT without knowing much more
about why I should be making it.

-kevin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 195 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20101214/bf6e4c19/attachment.sig>