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

John Siracusa siracusa at mindspring.com
Wed Jan 18 16:43:46 GMT 2006


On 1/18/06, Dmitri Bichko <dbichko at aveopharma.com> wrote:
>> On 1/18/06 6:36 AM, Tim Bunce wrote:
>>> On Tue, Jan 17, 2006 at 08:12:48PM -0500, John Siracusa wrote:
>>>> 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.
>>> 
>>> That's a database-specific issue. What database were you using?
>>> 
>> Postgres.
>> 
> Does VACUUM ANALYZEing after dropping the index help?

Maybe...I'll try it.  But it won't help in a web server environment because
of the obvious race.

-John






More information about the ClassDBI mailing list