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

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

From: Dmitri Bichko
Subject: RE: [CDBI] Class::DBI vs DBIx::Class
Date: 16:22 on 18 Jan 2006
> On 1/18/06 6:36 AM, Tim Bunce wrote:
> > On Tue, Jan 17, 2006 at 08:12:48PM -0500, John Siracusa wrote:
> >> On 1/17/06 7:56 PM, Tim Bunce wrote:
> >>> Class::DBI and DBIx::Class (and others) should probably=20
> be passing 3=20
> >>> for the $if_active parameter. Set it and forget it.
> >>=20
> >> I explored that a while ago (Rose::DB::Object passes 3 as you=20
> >> suggest), but it still doesn't account for the situation=20
> where the db=20
> >> supports server-side prepared statements and the schema changes=20
> >> between calls.  I encountered this in my benchmark suite, which=20
> >> creates and drops indexes as part of its execution.  Any statement=20=

> >> that was prepare_cache()d server-side when the indexes=20
> existed will=20
> >> fail if execute()d after the indexes are dropped.
> >=20
> > That's a database-specific issue. What database were you using?
>=20
> Postgres.

Does VACUUM ANALYZEing after dropping the index help?

Dmitri

The information transmitted is intended only for the person or entity to =
which it is addressed and may contain confidential and/or privileged mate=
rial. Any review, retransmission, dissemination or other use of, or takin=
g of any action in reliance upon, this information by persons or entities=
 other than the intended recipient is prohibited. If you received this in=
 error, please contact the sender and delete the material from any comput=
er

_______________________________________________
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