Re: [CDBI] Class::DBI vs DBIx::Class

[prev] [thread] [next] [Date index for 2006/01/18]

From: John Siracusa
Subject: Re: [CDBI] Class::DBI vs DBIx::Class
Date: 01:12 on 18 Jan 2006
On 1/17/06 7:56 PM, Tim Bunce wrote:
> Class::DBI and DBIx::Class (and others) should probably be passing 3
> for the $if_active parameter. Set it and forget it.

I explored that a while ago (Rose::DB::Object passes 3 as you suggest), but
it still doesn't account for the situation where the db supports server-side
prepared statements and the schema changes between calls.  I encountered
this in my benchmark suite, which creates and drops indexes as part of its
execution.  Any statement that was prepare_cache()d server-side when the
indexes existed will fail if execute()d after the indexes are dropped.

So, unfortunately, there's no way to totally remove the need to manually
control the use of prepare_cached().

-John



_______________________________________________
ClassDBI mailing list
ClassDBI@xxxxx.xxxxxxxxxxxxxxxx.xxx
http://lists.digitalcraftsmen.net/mailman/listinfo/classdbi

(message missing)

[CDBI] Class::DBI vs DBIx::Class
David Lloyd 00:29 on 17 Jan 2006

Re: [CDBI] Class::DBI vs DBIx::Class
Matt S Trout 01:18 on 17 Jan 2006

Re: [CDBI] Class::DBI vs DBIx::Class
Tim Bunce 10:04 on 17 Jan 2006

Re: [CDBI] Class::DBI vs DBIx::Class
Tim Bunce 00:15 on 28 Feb 2006

Old announce thread
Matt S Trout 15:29 on 28 Feb 2006

Re: [CDBI] Class::DBI vs DBIx::Class
Brad Bowman 11:07 on 17 Jan 2006

Re: [CDBI] Class::DBI vs DBIx::Class
yoorobot 15:14 on 17 Jan 2006

Re: [CDBI] Class::DBI vs DBIx::Class
Matt S Trout 16:15 on 17 Jan 2006

Re: [CDBI] Class::DBI vs DBIx::Class
Christopher H. Laco 16:10 on 17 Jan 2006

Re: [CDBI] Class::DBI vs DBIx::Class
Perrin Harkins 16:42 on 17 Jan 2006

Re: [CDBI] Class::DBI vs DBIx::Class
Ryan Tate 18:30 on 17 Jan 2006

Re: [CDBI] Class::DBI vs DBIx::Class
Matt S Trout 01:27 on 18 Jan 2006

Re: [CDBI] Class::DBI vs DBIx::Class
Matt S Trout 18:40 on 17 Jan 2006

Re: [CDBI] Class::DBI vs DBIx::Class
Perrin Harkins 18:44 on 17 Jan 2006

RE: [CDBI] Class::DBI vs DBIx::Class
Dmitri Bichko 16:22 on 18 Jan 2006

Re: [CDBI] Class::DBI vs DBIx::Class
John Siracusa 16:43 on 18 Jan 2006

RE: [CDBI] Class::DBI vs DBIx::Class
Dmitri Bichko 17:49 on 18 Jan 2006

RE: [CDBI] Class::DBI vs DBIx::Class
Perrin Harkins 18:03 on 18 Jan 2006

Re: [CDBI] Class::DBI vs DBIx::Class
John Siracusa 18:05 on 18 Jan 2006

Re: [CDBI] Class::DBI vs DBIx::Class
John Siracusa 18:06 on 18 Jan 2006

RE: [CDBI] Class::DBI vs DBIx::Class
Dmitri Bichko 18:20 on 18 Jan 2006

Re: [CDBI] Class::DBI vs DBIx::Class
Matt S Trout 19:00 on 17 Jan 2006

Re: [CDBI] Class::DBI vs DBIx::Class
Simon Wilcox 19:16 on 17 Jan 2006

Re: [CDBI] Class::DBI vs DBIx::Class
Perrin Harkins 20:30 on 17 Jan 2006

Re: [CDBI] Class::DBI vs DBIx::Class
Tim Bunce 00:56 on 18 Jan 2006

Re: [CDBI] Class::DBI vs DBIx::Class
John Siracusa 01:12 on 18 Jan 2006

Re: [CDBI] Class::DBI vs DBIx::Class
Tim Bunce 11:36 on 18 Jan 2006

Re: [CDBI] Class::DBI vs DBIx::Class
John Siracusa 12:37 on 18 Jan 2006

Re: [CDBI] Class::DBI vs DBIx::Class
Matt S Trout 01:21 on 18 Jan 2006

Re: [CDBI] Class::DBI vs DBIx::Class
Tim Bunce 11:37 on 18 Jan 2006

Re: [CDBI] Class::DBI vs DBIx::Class
Tim Bunce 23:43 on 18 Jan 2006

Re: [CDBI] Class::DBI vs DBIx::Class
Ryan Tate 23:57 on 18 Jan 2006

Generated at 20:44 on 01 Mar 2006 by mariachi v0.52