Re: [Q] Constructing a Cursor in PL/SQL from a string passes from Pro*C
Date: Sat, 25 Apr 1998 15:02:57 GMT
Message-ID: <3543fa2c.2091708_at_news.u-net.com>
Larry Leung <larryleung_at_poboxes.com> wrote (in <3541F262.BF7A017C_at_poboxes.com>)...
| The program logic is kinda simple. A cursor is created by a big SQL
| statement then it is looped thru record by record, meanwhile each
| fetched row needs to do some processing on. ie, accessing at most
| 3 tables from database. Then writes to 2 tables.
|
| The problem now is i am told the performance is kinda poor. it now runs
| 1 hour to 3 hours depending on the load of the server. (i wanted to get
| a more accurate statistics but this is another question)
|
[snip]
Hello,
I would have thought that using array processing, it would be rather
quick. I am not sure how moving the logic into (server-side) PL/SQL
will help.
So, the question is, are you using host arrays in your program?
graham Received on Sat Apr 25 1998 - 17:02:57 CEST