Re: [rt-users] Changing database connection options?

2010-12-14 Thread hubert depesz lubaczewski
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

Re: [rt-users] Changing database connection options?

2010-12-14 Thread 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

Re: [rt-users] Changing database connection options?

2010-12-14 Thread hubert depesz lubaczewski
On Tue, Dec 14, 2010 at 10:43:18AM -0500, Kevin Falcone wrote: 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

Re: [rt-users] Changing database connection options?

2010-12-14 Thread Kevin Falcone
finally - when using short, simple queries - prepared statements can actually work worse than normal queries, because they need more roundtrips client-server to do the same task. I suspect we'd need to see benchmarks of RT on versions of postgres from 8.1 - 9 to be able to really evaluate

Re: [rt-users] Changing database connection options?

2010-12-13 Thread Kevin Falcone
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