[CDBI] Class::DBI vs DBIx::Class
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
>>> That's a database-specific issue. What database were you using?
> 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.
More information about the ClassDBI