| Author |
Message
|
| malammik |
 Posted: Mon Dec 03, 2007 12:30 pm Post subject: Stored Procedure ResultSet or RecordSet |
 |
|
Partisan
Joined: 27 Jan 2005
Posts: 397
Location: Philadelphia, PA
|
I am going to call a stored procedure from within ESQL using MB6. Will the resultset of a query get loaded entirely into memory or does broker maintain some sort of a fetching mechanism between the db the thread accessing output tree?
_________________
Mikhail Malamud
http://www.netflexity.com
http://groups.google.com/group/qflex |
|
| Back to top |
|
 |
| mgk |
| Posted: Mon Dec 03, 2007 3:24 pm Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
The entire result will be brought back into the broker at the location specified on the CALL.
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. |
|
| Back to top |
|
|
| malammik |
| Posted: Mon Dec 03, 2007 3:30 pm Post subject: |
|
|
Partisan
Joined: 27 Jan 2005
Posts: 397
Location: Philadelphia, PA
|
Thanks a lot for the response. It really really help to have folks from development here.
I should've asked this in the original post. But what are my options if I would like to get an actual cursor to the result set on a db side rather than waiting for the whole resultset get loaded?
1. Using java compute node access db directly?
2. ???
3. ???
_________________
Mikhail Malamud
http://www.netflexity.com
http://groups.google.com/group/qflex |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Mon Dec 03, 2007 3:43 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Call a stored procedure to get the cursor and return the "next" result
Also, you might be able to use Passthru. Although I'm not entirely sure how.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| mgk |
| Posted: Tue Dec 04, 2007 1:29 am Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
Can you explain why you want to do this?
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. |
|
| Back to top |
|
|
| malammik |
| Posted: Tue Dec 04, 2007 6:27 am Post subject: |
|
|
Partisan
Joined: 27 Jan 2005
Posts: 397
Location: Philadelphia, PA
|
The reason, I need to do this is because as a result of an incoming message, I will have to potentially retrieve as many as 100K records and propagate them. Also my SLAs are very demanding and I would rather not wait for the DB to get ALL records and rather give it time to prefetch while I am processing.
_________________
Mikhail Malamud
http://www.netflexity.com
http://groups.google.com/group/qflex |
|
| Back to top |
|
|
|
|
