DBD::Oracle and bulk operations
[email protected] (Johannes Gritsch)
| Newsgroups | perl.dbi.users |
|---|---|
| Message-ID | <[email protected]> |
Hi! Since I came into this topic while writing a script: What does DBD::Oracle know about bulk operations? In PL/SQL you can speed up your cursor loops by using bulk fetches and/or bulk updates/inserts. Instead of operating on single rows you use arrays of rows. Since DBI does not support it directly (from what I know), it could be used when doing select_all_xxx calls. Sounds simple, and, yes, I know, it is not as easy as it sounds. But I think it would speed up this calls. PL/SQL gets a boost by 5 to 10, depending on hardware, OS and other things. When you search for DBD::Oracle and bulk, google only comes up with rather old documents dating back to 2004 and 2003. In one of those (from this mailinglist) I found: "It is not part of DBD::Oracle yet, though there are plans to include it in a future version." I'm a regular reader of this mailing list and I wonder that this topic did not come up again in recent years - or I just missed it ... cu hannes -- Johannes Gritsch Unix consultant and Oracle trainer Vienna, Austria