[Dbix-class] Turning off prepared statements for LIKE searches

[Jacob Bunk Nielsen]

Toby Corkindale <toby.corkindale at strategicdata.com.au> writes:
> Jacob Bunk Nielsen wrote:
> 
>> I have read an interesting blog post about how prepared statements in
>> PostgreSQL does not work well with LIKE searches. It can be found at:
>> http://blog.endpoint.com/2009/08/debugging-prepared-statements.html
>
> my $dbh = DBI->connect(
> 	'dbi:Pg:dbname=myDatabase', $user, $passwd,
> 	{ pg_server_prepare => 0 }
> );

Thank you for your help. It turns out that I was actually hit by an
index-related problem rather than a problem related to prepared
statements as I thought.

Best regards

Jacob