On 2005-12-17, David Manura <[EMAIL PROTECTED]> wrote: > Why do the higher-level DBI methods such as selectall_arrayref() > internally use prepare() rather than prepare_cached()? or at least why > is there no option to enable that? It seems that the only way to > utilize DBI's internal statement handling caching is to directly call > prepare_cached(), but managing that is not as convenient or transparent > as just using the higher-level methods such as selectall_arrayref().
I think I had a "use case" to address this: http://www.mail-archive.com/dbi-users%40perl.org/msg24261.html In my case "prepare_cached()" didn't scale up well, and I needed to turn it off. However, I probably had an edge case. Maybe it makes sense to cache to be default and have an option to turn it off. Mark -- http://mark.stosberg.com/
