PRO*C,Cursor Limits,Reducing the cursor requirement:HELP
From: <vinaya_s1_at_blrv1.verifone.com>
Date: Tue, 31 Jan 95 01:24:10 GMT
Message-ID: <1995Jan30.215142.2728_at_sfov1.verifone.com>
Received on Tue Jan 31 1995 - 02:24:10 CET
Date: Tue, 31 Jan 95 01:24:10 GMT
Message-ID: <1995Jan30.215142.2728_at_sfov1.verifone.com>
Hello!
I am writing a multi-threaded program, which may contain upto 128 threads.
each thread will do the following:
+ open Table A and read one row at a time, till all rows are read
and processed. The processing will be based on the data retrieved.
+ If necessary, the thread will recursively read another table,
retrieve row by row and process it, and then finally return control to the table from which this was called.
+ the thread will continue to process the other NOT-PROCESSED rows
in the original table. My program must handle the above table recursion. System : Oracle 7.0.16
Questions :
1. Which is the best method of handling this?
2. How can I reduce the number of cursors used.? Can I have about 500
cursors in a single process?
3. Most of the threads may be (will be!) reading the same Tables and hence
can I reduce the database FETCHes and improve the performance.
4. Has anyone faced similar situations?
Any help in this regard will be useful.
Thanks in advance
Vinaya_S1_at_blrv1.verifone.com
Received on Tue Jan 31 1995 - 02:24:10 CET